Forum Discussion
SQL to DAX
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
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