Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date table and multiple columns/tables

Hi all, 

Hi all, 

 

I have a data table as part of my report - however, I have 3 separate dates that I need it to associate with across two tables. For example:

  • Contact table - Latest review
  • Contact table - Latest contact

  • Status table - Last update

I want to plot the various times each record has been updated over the duration of time, so one axis on the report would be the date table - and then with the various dates for each of these columns against the relevant dates on it. 

 

I can only have one active relationship, so I cannot seem to plot multiple dates from multiple columns onto a single report? 

 

That can't be right... Not sure if I'm just having a day when the obvious answer is eluding me... 

 

 

 

  • You can activate the relationships inside measures, e.g. 

    Num reviews =
    CALCULATE (
        COUNTROWS ( Contact ),
        USERELATIONSHIP ( 'Date'[Date], Contact[Last review date] )
    )
    
    Num contacts =
    CALCULATE (
        COUNTROWS ( Contact ),
        USERELATIONSHIP ( 'Date'[Date], Contact[Last contact date] )
    )
    

2 Replies

  • You can activate the relationships inside measures, e.g. 

    Num reviews =
    CALCULATE (
        COUNTROWS ( Contact ),
        USERELATIONSHIP ( 'Date'[Date], Contact[Last review date] )
    )
    
    Num contacts =
    CALCULATE (
        COUNTROWS ( Contact ),
        USERELATIONSHIP ( 'Date'[Date], Contact[Last contact date] )
    )
    
    • Anonymous's avatar
      Anonymous
      Not applicable

      Ah - perfect! Thank you so much