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.
Hello,
I would like to look for a string included in my DAX formulas. Is there any way to do it ?
I unzipped the pbix file but I couldn't find my DAX formulas in any file.
Subsequently, it would be great to export/edit all DAX formulas to be able to compare them.
Thanks in advance for any help
Didier
Solved! Go to Solution.
I found a much better way by searching from a Power BI report. You can even search in more than one report.
Of course, you can export the formulas into Excel.
User manual and sources are in the first tab of the report in GitHub : https://github.com/didierterrien/Power-BI-assistant
I moved the pbix file to GitHub : https://github.com/didierterrien/Power-BI-assistant
Very good tutorial by Ruth Pozuelo (Curbal) : https://www.youtube.com/watch?v=Jg7n_cLjtTw
I found a way to do it in DAX studio after connecting to the Power BI report:
// Uncomment the query you need // Query to get columns : //select [ExplicitName] as [Column name], [Expression] as [Formula] from $SYSTEM.TMSCHEMA_COLUMNS where [Type]=2 and [SystemFlags]=0 // Query to get measures : select [Name] as [Measure name],[Expression] as [Formula] from $SYSTEM.TMSCHEMA_MEASURES
So glad I found this on the community board, here.
I tried this and it worked. This is a huge help. Thanks @campagnol54!
I found a much better way by searching from a Power BI report. You can even search in more than one report.
Of course, you can export the formulas into Excel.
User manual and sources are in the first tab of the report in GitHub : https://github.com/didierterrien/Power-BI-assistant
I moved the pbix file to GitHub : https://github.com/didierterrien/Power-BI-assistant
Very good tutorial by Ruth Pozuelo (Curbal) : https://www.youtube.com/watch?v=Jg7n_cLjtTw
As far as I know, there is no way available. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |