How can I show the latest row data accordingly as of latest date?

[mericok]

Hi Guys,

I want to show the latest row data accordingly as of the latest date and time in my BI report. I shared an attached picture. For example, I want to show WTV_TARGETQTY row value (445) accordingly the latest date&time which is 8/22/2018 7:30 AM. I set a filter latest date&time. It's work. Here is the formula for this: mAXdATE = CALCULATE(MAX(Target[WTV_DATE_TIME]), ALL(Target))

Actually, I used that formula for showing the latest row accordingly date&time but it gave a different value. I appreciate for now to everybody.

Measure = LASTNONBLANK(Target[WTV_TARGETQTY],0)

[Anonymous · Accepted solution]

@mericok use this

value =

var maxdate = CALCULATE(MAX(Target[WTV_DATE_TIME]), ALL(Target))

return calculate(sum(Target[WTV_TARGETQTY]), FILTER(Target, Target[WTV_DATE_TIME]) = maxdate