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 All
Adv of DAX is i can keep all script for record the field.
Power Quary Adv is very easy to recode field but it is unable to create a script.
Paul Yeo
Not sure what you mean by script but you can view the M code behind your query by hitting the Advanced Editor button in the ribbon. Much more is possible with M than just what is in the ribbon.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi mahoney
Thank you very much , i just check and i know what you mean.
Hi @Paulyeo11
If what you are referring to is the ability to create a 'script' that can be reused then yes, PQ does this. It's just that the M code is 'hidden' unless you open the Advanced Editor.
If you use the GUI to create your transformation steps then the M code is created by PQ in the background.
This 'script' can then be shared in several ways including as an Excel workbook (if using PQ in Excel), a PBIX file (if using PQ in Power BI) or just as a text file (copy/paste the code).
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hello, sir
I'm starting to see the beauty of the M-code
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |