Forum Discussion
Help with Measure
Hi all, I am ccurrently working on a project in BI and am running into an issue. Basically I am trying to get a value in one table into another table based on a date and a vendor. I have been try...
Hi Anonymous
Please try this:
Here I create a set of sample:
Table:
Tbale 2:
Then add a measure:
MEASURE = VAR _currentDate = MAX ( 'Table 2'[Table_Date] ) VAR _currentItem = SELECTEDVALUE ( 'Table 2'[Table_Market Item] ) RETURN SUMX ( FILTER ( 'Table', 'Table'[Date] = _currentDate && 'Table'[Market Item] = _currentItem ), 'Table'[Price] )The result is as follow:
It's worth noting that there are no relationship between the 2 tables:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Please try this:
Here I create a set of sample:
Table:
Tbale 2:
Then add a measure:
MEASURE =
VAR _currentDate =
MAX ( 'Table 2'[Table_Date] )
VAR _currentItem =
SELECTEDVALUE ( 'Table 2'[Table_Market Item] )
RETURN
SUMX (
FILTER (
'Table',
'Table'[Date] = _currentDate
&& 'Table'[Market Item] = _currentItem
),
'Table'[Price]
)
The result is as follow:
It's worth noting that there are no relationship between the 2 tables:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.