Calculated Column based on a condition

[Anonymous]

Hi, 

I have the following table with datetime and level. And what I want is to create a calculated column, which starts with 1 and increases every time when level=999. Looks simple to do. But I couldnt do it using DAX. Btw I want to create it with DAX and not with M. 

Best regards

[v-juanli-msft]

Hi @Anonymous 

amitchandak's formula is useful despite of a little grammar error.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

countx(filter(table,[date time]<= earlier[date time] && [Level] ="999"),[Level] )