Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Line chart

Hi.

 

I have this cumulative line chart but I would like to change it. As of this moment it just add up all the intern status but I would like it to substract the number as well fx 22/11/2022 there was 19 but at the 23/11/2022 it actually dropped to 17 - how do I show that in my chart?

 

I have this equation: 

cumm =
IF (
    COUNT ( Data[Intern status] ) <> BLANK (),
    CALCULATE (
        COUNT ( Data[Intern status] ),
        FILTER ( ALL ( Kalender[Date] ), 'Kalender'[Date] <= MAX ( Kalender[Date] ) )
    )
)

 

Hope it makes sense.

 

 

Best regards,

Lisa 

 

Need Help

4 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Anonymous 

     

    Is this the result you expect?

    If not, please provide more details.

     

    Best Regards,

    Community Support Team _Charlotte

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi v-zhangti.

       

      Yes but I have text values not numeric values. 
      So I dont know the right measure. 

       

       

      Best regards,

      Lisa 

       

      • v-zhangti's avatar
        v-zhangti
        Community Support
        3 years ago

        Hi, Anonymous 

         

        How is this text column related to the date column? Can you provide sample data for testing? Sensitive information can be removed in advance.You can show it with pictures. I look forward to your response.

         

        Best Regards,

        Community Support Team _Charlotte

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