Forum Discussion

DHB's avatar
DHB
Helper V
9 years ago
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...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    DHB

     

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

DHB

 

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,

DHB's avatar
DHB
Helper V
9 years ago

Thanks for taking the time to help.  The solution works perfectly.