The SQL Code Behind A Dax Measure

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%2Csqlservicebroker%2Csqlsecurity%2Csqldatabaseengine%2Csqldocumentation%2Csqlsetupandupgrade%2Csqldisasterrecovery%2Csqlnotificationservices%2Csqlce%2Csqlgetstarted%2Csqldatabasemirroring%2Csqlexpress%2Csqldriverforphp%2Csqldatawarehousing%2Csqlsearch%2Csqlspatial%2Csqlserversamples%2Cstreaminsight%2Cdatabasedesign%2Csqlservermigration%2Csqlmds%2Csqlkjappmsmgmt%2Csqlkjpowerpivotforexcel%2Csqlkjpowerpointforsharepoint%2Csqlkjmanageability%2Csqldru%2Csqldataqualityservices%2Cssdt%2Csqlinmemory&filter=alltypes&sort=lastpostdesc

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.