Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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 ,
Try LASTNONBLANKVALUE(Table[Date], [Measure])
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.
Hi ! The logic is that number is the last row in the table.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |