Return Latest Value Using Date Slicer

Hi sya,

Please try this code. it works here with the provided pwbi

new measure =

VAR yearmax =

CALCULATE ( MAX ( 'Date'[Year] ), REMOVEFILTERS ( 'Date' ) )

VAR monthselect =

SELECTEDVALUE ( 'Date'[Month Name] )

var monthnumb=CALCULATE(max('Date'[Month]),'Date'[Month Name]=monthselect)

VAR _Datemax =

date(yearmax,monthnumb,1)

VAR _Maxdatedsoalldates =

CALCULATE ( MAX ( Sheet1[Month] ), REMOVEFILTERS ( 'Date' ) )

VAR _Maxdatedso =

CALCULATE ( MAX ( Sheet1[Month] ),'Date'[Year]=yearmax)

var dsomaxperiod=CALCULATE ( [DSO Allocated],Sheet1[Month]=_Maxdatedsoalldates)

VAR result =

if(ISBLANK(_Maxdatedso),

CALCULATE ( [DSO Allocated],Sheet1[Month]=_Maxdatedsoalldates,REMOVEFILTERS('Date'[Month Name])),IF (_Maxdatedso <= _Datemax,

CALCULATE ( [DSO Allocated],'Date'[Year]=yearmax)))

RETURN

result

 

Hi,

Try these measures

Measure = CALCULATE([DSO Allocated],LASTNONBLANK('Date'[Date],CALCULATE([DSO Allocated])))

Measure 2 = maxx(summarize(calculatetable('Date',datesbetween('Date'[Date],date(2022,1,1),[Last date of selected month])),'Date'[Year],'Date'[Month Name],"ABCD",[Measure]),[ABCD])

Hope this helps.