Forum Discussion

Mp1977's avatar
Mp1977
Icon for Helper II rankHelper II
6 years ago
Solved

Last 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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Mp1977
Icon for Helper II rankHelper II
6 years ago

V-lianl-msft ,

Thank you very much ! It work quite well.