AnonymousNot applicable6 years agoSolvedsql to daxHi,What is the DAX for the following sql please?select field1, field2from table1 Thank youAnonymous to Anonymous6 years agoHi,I think summarize is more like 'group by'.Thanks.
3 RepliesReplies sorted by Most LikedAnonymousNot applicable6 years agoIf 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.AnonymousNot applicable to Anonymous6 years agocan summarize do the same thing?AnonymousNot applicable to Anonymous6 years agoHi,I think summarize is more like 'group by'.Thanks.
AnonymousNot applicable6 years agoIf 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.
Related contentConvert SQL into DAXDAX equivalent of SQL's NOT IN?DAX equivalent of SQL LIKEConverting SQL into DAX...SQL TO DAX
