How to show previous cumulative value if no value to cumulate and blank if condition applied?

[Cortana]

I have data like this- 

Id	Stage	Day	StageNO
6g00003	stage 6	244	6
6g00003	stage 5		5
6g00003	stage 4	21	4
6g00003	stage 3		3
6g00003	stage 2		2
6g00003	stage 1		1

NB: Each ID has 4 stages. Every time an id will first enter stage 6, and the 5,4,3,..1. and how many days they are staying in that stage is showing on the Day column.  Here this id was in stage 6 for 244 days. It was in stage 5 but we have no data for that. Then it goes to stage 4 and stays for 21 days. this is his current stage as we don't have any future value for this ID. 

I want a cumulated column that will show the cumulative day count but like this - 

Here, as the current stage is 4, the cumulative value for stage 5 is shown as the previous value. But after stage 4,  it does not have any value in future stages. So it would be blank. 
Can anyone help me with that? 

[sam_gift]

Hi did you find the solution?

I came up with same issue

[Cortana]

Hello @Jihwan_Kim 
I think you understood what I meant but It gave me blank values when I applied this to my table. 

[Jihwan_Kim]

Hi,

If you are looking for creating a new calculated column, please check the below picture and the attached pbix file.

Cumulative days measure CC: =
VAR _minstage =
    MINX ( FILTER ( Data, Data[Day] <> BLANK () ), Data[StageNO] )
RETURN
    IF (
        Data[StageNO] >= _minstage,
        CALCULATE (
            SUM ( Data[Day] ),
            WINDOW (
                1,
                ABS,
                0,
                REL,
                SUMMARIZE ( ALL ( Data ), Data[Id], Data[Stage], Data[StageNO], Data[Day] ),
                ORDERBY ( Data[StageNO], DESC, Data[Stage], DESC ),
                KEEP,
                PARTITIONBY ( Data[Id] )
            )
        )
    )

[Cortana]

Hello, @Jihwan_Kim Thank you for your response. But It does not work on mine either way. It does not show value for stage 4. I mean where there is no value for Day. Also, it is not being cumulated. 

I have found another way to do that. For that I needed another column Current_stage. I thought it would be doable easily without it.

I used that in my calculation which gave me my the desired output. But if you have solution without using that column I will appreciated that too. 

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new measure.

Cumulative days measure: =
VAR _minstage =
    CALCULATE (
        MIN ( Data[StageNO] ),
        FILTER ( ALL ( Data ), Data[Day] <> BLANK () )
    )
RETURN
    IF (
        MAX ( Data[StageNO] ) >= _minstage
            && HASONEVALUE ( Data[StageNO] ),
        CALCULATE (
            SUM ( Data[Day] ),
            WINDOW (
                1,
                ABS,
                0,
                REL,
                SUMMARIZE ( ALL ( Data ), Data[Id], Data[Stage], Data[StageNO], Data[Day] ),
                ORDERBY ( Data[StageNO], DESC, Data[Stage], DESC ),
                KEEP,
                PARTITIONBY ( Data[Id] )
            )
        )
    )