DAX command "if" statement not finding column

John21Morales — Sun, 01 Jan 2023 20:01:20 GMT

New to Power BI, I couldn't find out how to put the column "Churn Label" into the IF Command, so I went to the solutions (Of the exercise I was doing for DataCamp) to find out. It turns out, I knew how to do it but the way I was typing it in was not working.

Anyways, I tried to type it in as "Churneb" in the solutions file, and the same exact DAX command did not work. Is there something I am missing?

Thanks in advance!

Re: DAX command "if" statement not finding column

tamerj1 — Sun, 01 Jan 2023 20:18:53 GMT

Hi John21Morales

You are creating a measure. You can use the same formula to create a calculated column. Otherwise, you need to wrap the column with SELECTEDVALUE:

IF ( SELECTEDVALUE ( 'Table'[Column] ) = "ABC", 1, 0 )

topic Re: DAX command "if" statement not finding column in DAX Commands and Tips

DAX command "if" statement not finding column

Re: DAX command "if" statement not finding column