Forum Discussion

schoden's avatar
schoden
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Show data progress in time

Hi Community,    I have a very simple data from excel sheet. I want to show amount in all months from "Opened"  till "Closed" Status. Essentially I want to show from Jan till July for this ID "a"....
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    schoden ,My bad

    calculate(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))

schoden's avatar
schoden
Icon for Post Partisan rankPost Partisan
5 years ago

Hi amitchandak 

I got this message 

 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

schoden ,My bad

calculate(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))

  • schoden's avatar
    schoden
    Icon for Post Partisan rankPost Partisan
    5 years ago

    Thanks heap amitchandak  Obtained the result.

     

  • schoden's avatar
    schoden
    Icon for Post Partisan rankPost Partisan
    5 years ago

    Hi amitchandak , 

     

    Sorry for for gap but I am struggling to get lastnonblankvalue for EACH ID in Each MONTH ?

    For example in Jan 2020 there are two IDS - show all value for all each ID.

    Will really appreciate.