Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is there some kind of way to convert a DAX measure to an SQL statement?
Thanks.
Solved! Go to 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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |