Forum Discussion
Solved
relationships between fields
I've configured some files in PBI like this... I want a table to show me the update dates (a column in each of the 4 files on the right) by course (from the course dimension on the left). Whe...
In your scenario, it seems you build the relationships between Course dimension to all other 4 dimensions based on ID column. Those 4 dimensions have no relationships between each other. So we can't put the 4 update dates into same visual. You have to create 4 measures to return the recent update date in corresponding table. See my sample below:
Then create measures to return the MAX date:
recent Dim_A Date = CALCULATE(MAX(Dim_A[Dim_A_Date]))
recent Dim_B Date = CALCULATE(MAX(Dim_B[Dim_B_Date]))
recent Dim_C Date = CALCULATE(MAX(Dim_C[Dim_C_Date]))
Regards,
Is there some DAX I could use to filter out multiples in the assignment, quiz and discussion dimension tables and keep only the most recent updated date?