Forum Discussion
Anonymous
5 years agoNot applicable
Count days in single column until reference ID appears again
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 |
3 Replies
- amitchandak
Super User
Anonymous , what is logic of days Active
- AnonymousNot applicable
Logic should be to count untill a stage number is => current stage number with matching Ref ID.
- v-easonf-msft
Community Support
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