Date table and multiple columns/tables

[Anonymous]

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... 

[johnt75 · Accepted solution]

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]

Ah - perfect! Thank you so much