Forum Discussion
Solved
Max or Latest date
I have a fact table related to a date table. I want a measure to get the latest date in the fact table data regardless of slicers. For example my data is upto yesterday 2024-12-19 and I want this t...
Hi Si_7777 ,
Latest Date (Ignore Slicers) =
CALCULATE(
MAX('FactTable'[DateColumn]),
ALL('FactTable')
)
please try this
Thank you both very helpful