Create dummy column with null values

[Anonymous]

Hello Team

I hope you are doing well.

I am trying to create a dummy column with null values ​​in DAX.

I'm trying to do the DAX equivalent of this SQL query:

Select null as ColumnA

Do you know how I can do it in DAX?
Thanks for your help.

[amitchandak]

@Anonymous , Try like

New column = blank()

or

new column  =""

[Anonymous]

Hello

Thank you for your help.

I try this but it doens't work.

EVALUATE SUMMARIZE ( blank())

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Please try the following dax:

EVALUATE SUMMARIZE ( Table,Table[column1],Table[column2],"newcolumn",blank())

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai