Forum Discussion
Return latest value
Hi all
How can I get the latest value from one column? So far I have been only able to create an average.
In the image below for example, I have 2 values. I would like to have returned the 88.43% since it it's the latest one (november 2019)
Pbi: https://1drv.ms/u/s!ApgeWwGTKtFdhmc6hMVmmqyeKKwZ?e=fsYfYL
Thanks!
10 Replies
o59393 , try
LASTNONBLANKVALUE(Table1[date],[Avergae of Next])
or
maxx(summarize(Table,Table[Facility_id],"_id",LASTNONBLANKVALUE(Table1[date],[Avergae of Next])),[_1])
Hi amitchandak
I got a blank:
I used on the measure the column that contain the value Next[Next] and then the average to have the value returned, also tried
LASTNONBLANKVALUE('date'[Start of Month],AVERAGE(NEXT[NEXT])) but go a blank.What do you see wrong?
Thanks!
The first column need to be a date or if month year then YYYYMM.
Refer
https://docs.microsoft.com/en-us/dax/lastnonblankvalue-function-dax
