Forum Discussion
Solved
Creating a new column using a text field
I'm trying to create a new column using a text column. If the text column is empty, I want the new column to have "0", if it is not empty, I want it to have a "1". Seems simple but I just can't come up with a working formula.
BAChizek , in power query
if [Column] = null or [column] ="" then 0 else 1
In DAX, new column
if(isblank([column] || [column]= "", 0,1)
1 Reply
BAChizek , in power query
if [Column] = null or [column] ="" then 0 else 1
In DAX, new column
if(isblank([column] || [column]= "", 0,1)