Forum Discussion
Helper IILast Value in the table
Hi !
I'm trying to get last value in the table that represent the actual balance. I tried LASTNONBLANK but it need a expression. I used 1 as the expression but I got the larger number for the last date, 22.908, but I need the number 22.818.
I appreciate any help.
Thank you
Hi Mp1977 ,
Create an index column in the query editor then create a measure like this.
Measure 2 = CALCULATE(LASTNONBLANKVALUE('Table (2)'[Index],SUM('Table (2)'[value])))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Mp1977Hi ! The logic is that number is the last row in the table.
samdthompsonMemorable Member
=CALCULATE([Measure],LASTDATE('Date'[Date]))Throw that into a card and you will see the max balance//If this is a solution please mark as such- Mp1977
Thank you for the reply ! But I need the last row value, the Max will bring other value than the last one, with the balance is higher at the beggining of the day.
- amitchandak
Super User
Mp1977 ,
Try LASTNONBLANKVALUE(Table[Date], [Measure])
V-lianl-msftCommunity Support
Hi Mp1977 ,
Create an index column in the query editor then create a measure like this.
Measure 2 = CALCULATE(LASTNONBLANKVALUE('Table (2)'[Index],SUM('Table (2)'[value])))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Mp1977
V-lianl-msft ,
Thank you very much ! It work quite well.
