DAX help

[Christianeb]

Hi everyone !  DAX is hard for me. I am hoping you guys could help me please ...

Is this what i'm supposed to do?

and this is what i've done, but it is obviously not right since it doesn't work. can someone help me please ? sorry for being such a newbie

[RayWu · Accepted solution]

Hi @Christianeb  on the last pic, 1 instead of "1"
And In powerquery do something along the lines of: = Table.AddColumn(#"previousstep", "Churned", each if [Churn label] = "Yes" then 1 else 0) oh this is a powerquery solution for a new collumn btw, there's probably some DAX magismo out there also

[Christianeb]

It works, Ty for help