topic Re: sql to dax in DAX Commands and Tips

sql to dax

Anonymous — Tue, 10 Sep 2019 08:01:03 GMT

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

from table1

Thank you

Anonymous — Tue, 10 Sep 2019 08:47:00 GMT

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 — Tue, 10 Sep 2019 08:49:20 GMT

can summarize do the same thing?

Anonymous — Tue, 10 Sep 2019 08:52:59 GMT

Hi,

I think summarize is more like 'group by'.

Thanks.