The SQL Code Behind A Dax Measure

[analystict]

Hi,

Is there some kind of way to convert a DAX measure to an SQL statement?

Thanks.

[v-xuding-msft · Accepted solution]

Hi @analystict ,

There isn’t an option to convert a DAX measure to an SQL statement directly in Power BI.   You can reference  the following link to convert manually.

https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

If you want to check the SQL statement behind a DAX Measure. You can reference this link to use SQL profiler to check the SQL code . But the functions that can be used in DAX are not necessarily available in SQL statement, and the reverse is also true.

For any question about T-SQL, I would suggest you post thread on Transact_SQL forum.  When you create a  thread, please post sample data to show others the original dataset and your expected result.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql%2Csqlreplication%2Cs...

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes using dax studio