sql to dax

[Anonymous]

Hi,
What is the DAX for the following sql please?
select field1, field2

from table1

Thank you

[Anonymous]

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]

can summarize do the same thing?

[Anonymous · Accepted solution]

Hi,

I think summarize is more like 'group by'.

Thanks.