Cumulative line chart based on text value

[Anonymous]

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 

[v-yadongf-msft · Accepted solution]

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.

[Shaurya]

Hi @Anonymous,

You can the below the DAX formula to create a cumulative totals column:

Cumulative = SUMX('Table',IF('Table'[Date]<=EARLIER('Table'[Date]),'Table'[Antal of Intern Status],0))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[Anonymous]

"Antal of Intern status" is not an actual column is just something I converted for a visual table. So what do I do?

And I have a calender table, is that the one that I should use as "Table" in your eqaution?