Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Si_7777
Frequent Visitor

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 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.

1 ACCEPTED SOLUTION
anmolmalviya05
Super User
Super User

Hi @Si_7777 ,

Latest Date (Ignore Slicers) =
CALCULATE(
MAX('FactTable'[DateColumn]),
ALL('FactTable')
)

please try this

View solution in original post

3 REPLIES 3
Si_7777
Frequent Visitor

Thank you both very helpful

anmolmalviya05
Super User
Super User

Hi @Si_7777 ,

Latest Date (Ignore Slicers) =
CALCULATE(
MAX('FactTable'[DateColumn]),
ALL('FactTable')
)

please try this

danextian
Super User
Super User

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 ) )

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.