Loading

Pass the Value From One Data Source to Another When There Are No Relations Between Them

Udgivelsesdato: Apr 26, 2025
Opgave

How to pass a value from one data source to another when there are no relations between them?

For example, there are 2 data sources like the below image. 
User-added image
Data A will update with the latest date every day. How do we pass the latest date in Data A to Data B and make calculations based on that?
Since Data A and Data B have no relation or common fields, it is difficult to Join them or Blend them.

Trin
Please set the necessary values as the default value for a parameter and use this parameter in another data source.
Since the parameter is common in one workbook, using the parameter could pass value from one data source to another.

The steps could be as follows:
1. Use the FIXED function to get the latest date in Data A.
User-added image

2. Create a parameter and set the calculation in Step 1 as [Values when workbook opens] value. This would let the parameter always get the latest date in Data A even if it is updated.
User-added image

3. Use the parameter in Step 2 to make calculations in Date B. This passes the value from Data A to Data B.
User-added image

Please also check the attached workbook for details.
Yderligere ressourcer
When specifying a value when the workbook opens, if there is more than one value, the workbook would not be able to choose a default value.
The calculation must also be view-independent so that the value won’t change as the viz changes. To do this, you can use a FIXED level of detail (LOD) expression that is not dependent on the structure of the viz. 

Please check the details in the below product help.
Create Parameters
 
Vidensartikelnummer

001458634

 
Indlæser
Salesforce Help | Article