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.

3 Replies

  • 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.

  • Shaurya's avatar
    Shaurya
    Memorable Member
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      "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?