Forum Discussion

Si_7777's avatar
Si_7777
Advocate II
1 year ago
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...
Tips and Tricks
  • anmolmalviya05's avatar
    anmolmalviya05
    1 year ago

    Hi Si_7777 ,

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

    please try this

danextian's avatar
danextian
Super User
1 year ago

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