Forum Discussion
DAX command "if" statement not finding column
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!
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 )
1 Reply
- tamerj1
Community Champion
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 )