Count days in single column until reference ID appears again

[Anonymous]

Hello,

I am new to powerBI and i am trying to create a calculated column that counts the active days until the same reference ID appears again in the table then stops counting.

Desired outcome is the Days active column as below.

I have looked through the forums and found something close

but it creates the value to the next row as days between and im not clear how to alter the DAX to give the desired outcome.

Reference Number	Date Submitted	Stage Number	Days Active
1	01/01/2021	1	61
1	02/02/2021	2	63
1	03/03/2021	3	170

[amitchandak]

@Anonymous , what is logic of days Active

[Anonymous]

Logic should be to count untill a stage number is => current stage number with matching Ref ID.

[v-easonf-msft]

Hi,  @Anonymous 

I am sorry that your explanation has confused me even more, can you provide more data for research?

Best Regards,
Community Support Team _ Eason