Forum Discussion
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
- johnt75Super User
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] ) )- AnonymousNot applicable
Ah - perfect! Thank you so much