Forum Discussion
Filtering on 2 date fields in a table
Hi,
It will take a lot of time for me to walk you through all that i have done. To answer your specific question, the Custom column i created has converted two date columns into a single one by exploding each data of the date range into a single row. This has been done so that we can relate this single column to the Date column of the Calendar Table.
Please feel free to ask any specific questions that you may have.
try this:
[Measure that uses inactive relationship] =
CALCULATE (
[Same Measure that the active relationship uses],
USERELATIONSHIP ( DateTable[DateColumn], FactTable[created date] )
)Hi
that's great thanks and helps sum up the number of created inspections. What i need to do is show a list of created inspections and a list of closed inspections on the same report page using the same filters - similar to this. At the moment both reports show the same inspections just with the created date or completed date Any ideas? Thanks for your help.
change the tablename[create date] to [completed date] in the USERELATIONSHIP() function.
hi Anonymous,
Are these your expected results?
yes Ashish_Mathur! I would be very grateful if you could share how you have done this.
Many thanks
Jo.