Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

sql to dax

Hi, What is the DAX for the following sql please? select field1, field2 from table1   Thank you
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I think summarize is more like 'group by'.

    Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If you want to create a new table from existing table use below syantax:

Product Dummy = SELECTCOLUMNS( 'Product', "PName", 'Product'[Product Name], "PID", 'Product'[Product ID] )

Here I am creating Product Dummy table from Product table with just 2 fields.

Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    can summarize do the same thing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      I think summarize is more like 'group by'.

      Thanks.