topic Re: Creating a new column using a text field in DAX Commands and Tips

Creating a new column using a text field

BAChizek — Wed, 16 Mar 2022 15:58:39 GMT

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.

Re: Creating a new column using a text field

amitchandak — Wed, 16 Mar 2022 17:16:14 GMT

BAChizek , in power query

if [Column] = null or [column] ="" then 0 else 1

In DAX, new column

if(isblank([column] || [column]= "", 0,1)