Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cumulative line chart based on text value

Hi.   How do I make a cumulative line chart of this?  This is the same table - I would like a column next going 25/07 = 2, 06/09 = 3 and so on.  Best regards, Lisa         
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    This is my test table:

     

    Please try following measure:

    Measure = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])))

     

    I think this is the result you want:

     

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi Anonymous ,

 

This is my test table:

 

Please try following measure:

Measure = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])))

 

I think this is the result you want:

 

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.