Forum Discussion

PBI12345's avatar
PBI12345
Icon for Helper I rankHelper I
2 years ago
Solved

Dax request: Filter a table's values based on values from another table

Hello,   In the below scenario, I have two tables. I am trying to build a measure that returns the value from Table2 associated with the maximum date from Table1 where column Time = "Past".   In ...
  • Dangar332's avatar
    Dangar332
    2 years ago

    HI, PBI12345 

    If you have relationship b/w both tables on Date Column then try below measure.

    Measure =
var Max_date = calculate(max(table1[Date]),table1[time]="Past")
return
calculate(sum(table2[value]),Table2[date]=Max_date)



Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

HI, PBI12345 

If you have relationship b/w both tables on Date Column then try below measure.

Measure =
var Max_date = calculate(max(table1[Date]),table1[time]="Past")
return
calculate(sum(table2[value]),Table2[date]=Max_date)