Forum Discussion
Solved
Date Slicer
I have a date table and my fact table. My fact table has Due Dates. I want to have a slicer of dates that will filter the due dates of the table i have. for example: Slicer date is 31/08/20...
mussaenda add following two measures and see if it works
Is date before max date = VAR __date = MAX( 'Calendar'[Date] ) RETURN CALCULATE( COUNTROWS( 'Table 1' ), 'Table 1'[Due Date] <= __date)
Delay Days = DATEDIFF( MAX( 'Table 1'[Due Date] ), MAX( 'Calendar'[Date] ), DAY ) *
DIVIDE( [Is date before max date],[Is date before max date] )in table visual add following
- Doc No
- Due Date
- Delay Days
and you will get the result
Hi parry2k,
Should I create a relationship between the date table and the fact able using the due date and dates to create these?
Yay! Awesome it works!
Thank you!
But.. It only works on the table.
If I want to work it on the whole page like a filter?
I mean, The blank on the delay days meaure I want to hide on the whole page.
Can we convert it to a calculated column?
But, your mesaure is a big step forward for me. Thank you parry2k !!