Forum Discussion

Anonymous's avatar
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...
Need Help
  • v-deddai1-msft's avatar
    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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

 

New column = blank()

 

or

 

new column  =""

  • Anonymous's avatar
    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's avatar
      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