Forum Discussion

hama21's avatar
hama21
Helper I
3 years ago
Solved

Get last value (last date) when using filter

Hi, I'm have one database that's look like this: date value jan/22 4 feb/22 5 mar/22 6 abr/22 7 may/22 4 jun/22 5 jul/22 4 aug/22 6 sep/22   oct/22   n...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    hama21 , I Just Noticed VahidDM , Already replied. Check that first.

     

    Try like

     

    calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])) )

     

    or

     

    calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])), allselected())

amitchandak's avatar
amitchandak
Super User
3 years ago

hama21 , I Just Noticed VahidDM , Already replied. Check that first.

 

Try like

 

calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])) )

 

or

 

calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])), allselected())

  • hama21's avatar
    hama21
    Helper I
    3 years ago

    Thank you amitchandak Works perfectly! Could you please explain the differece between the measure I was trying and your measures?

     

    Thank you!