Forum Discussion
Solved
SQL to DAX
Hi, I would like to create a calculated table but don't know how to translate below to DAX? /****** Script for SelectTopNRows command from SSMS ******/ select distinct * from ( SELECT dist...
You could use this query in Power BI desktop directly.
Besides, there are big difference between T-SQL query and DAX query. You'd better to learn DAX basics before you can convert T-SQL to DAX, here are some useful links for you reference.
https://support.office.com/en-us/article/QuickStart-Learn-DAX-Basics-in-30-Minutes-51744643-c2a5-436a-bdf6-c895762bec1a?ui=en-US&rs=en-US&ad=US
https://www.sqlbi.com/topics/from-sql-to-dax/Regards,
Charlie Liao
Is there a reason you need this table as a calculated table using DAX?
It may be easier to use the Query Editor to import your tables (origin, destination, FreightPayer, and CRMOwner) as separate queries, rename the headers, then append into a single table.