Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 to be visible. If I refresh import the data will include today and then the measure should update. I have tried variations of Max data using All except.
Solved! Go to Solution.
Hi @Si_7777 ,
Latest Date (Ignore Slicers) =
CALCULATE(
MAX('FactTable'[DateColumn]),
ALL('FactTable')
)
please try this
Thank you both very helpful
Hi @Si_7777 ,
Latest Date (Ignore Slicers) =
CALCULATE(
MAX('FactTable'[DateColumn]),
ALL('FactTable')
)
please try this
Hi @Si_7777
Try these:
LatestDate =
--takes into consideration that there may be multiple fact tables and sales measure is referencing these tables.
CALCULATE ( LASTNONBLANK ( 'Date'[Date], [Sales] ), REMOVEFILTERS ( 'Date' ) )
LatestDate2 =
--assuming Sales is the only fact table
CALCULATE ( MAX ( Sales[Date] ), REMOVEFILTERS ( Sales ) )
Proud to be a Super User!
User | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |