Future date with latest data

Hi mohammadrafic 

Based on your sample data, I create a sample. See sample file attached bellow.

-

coz you want put values into card, in card there's no row context so you need to provide context to filter manually in measure,

Measure = 
var _currentMonth=CALCULATE(MAX('Table'[StartDate]),ALL('Table'))
var _selMonth=SELECTEDVALUE(dateSlicer[StartDate])
var _lastMonth=EDATE(_currentMonth,-1)
var _YTD1=CALCULATE(MAX('Table'[Forecast_YTD_AVG]),FILTER(ALL('Table'),'Table'[StartDate]=_lastMonth&&'Table'[TITLE]="Light-Total"))
var _YTD2=CALCULATE(MAX('Table'[Forecast_YTD_AVG]),FILTER(ALL('Table'),'Table'[StartDate]=_lastMonth&&'Table'[TITLE]="PZ-Total"))
var _YTD3=CALCULATE(MAX('Table'[Forecast_YTD_AVG]),FILTER(ALL('Table'),'Table'[StartDate]=_lastMonth&&'Table'[TITLE]="Ratawi-Total"))
var _YTD4=CALCULATE(MAX('Table'[Forecast_YTD_AVG]),FILTER(ALL('Table'),'Table'[StartDate]=_lastMonth&&'Table'[TITLE]="SUGAMT-Total"))
return
"Light-Total: "&_YTD1&"   PZ-Total: "&_YTD2&"   Ratawi-Total: "&_YTD3&"   SUGAMT-Total: "&_YTD4

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.