Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Create dummy column with null values

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.

v-deddai1-msft
5 years ago
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

3 Replies

amitchandak
Super User
5 years ago
Anonymous , Try like

New column = blank()

or

new column =""
- Anonymous
  Not applicable
  5 years ago
  Hello
  
  Thank you for your help.
  I try this but it doens't work.
  EVALUATE SUMMARIZE ( blank())
  - v-deddai1-msft
    Community Support
    5 years ago
    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