Line chart

[Anonymous]

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 

[v-zhangti]

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]

Hi @v-zhangti.

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

Best regards,

Lisa 

[v-zhangti]

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

[Anonymous]

@v-zhangti 

All orders have a registered date and an intern status, so people are able to see progress of the order. I would like to know how many orders are still open – so I would like it to add up all of the open status so e.g. yesterday I had 25 open orders but today I have only 23 because 2 were closed yesterday. And I would like to illustrate that in my line chart.

Best regards,

Lisa