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.
Solved! Go to Solution.
Of course. If there weren't, why would Microsoft bother creating and investing into two different technologies? DAX is a Data Analysis eXpression language and its goal is to facilitate data analysis. Power Query has a functional language, called M, which is a data mashup language. There are many, many benefits to data preparation in PQ but some of them are: 1) one can easily use recursion in M (not possible in DAX), 2) standard operations like pivoting, data imputation, string manipulation, statistical functions, using ML algorithms are one-click (or almost one-click) operations in PQ, 3) columns calculated in PQ are much, much, much better compressed than columns calculated in DAX (which are not compressed at all). There are many more benefits but the above come to my head right away.
Of course. If there weren't, why would Microsoft bother creating and investing into two different technologies? DAX is a Data Analysis eXpression language and its goal is to facilitate data analysis. Power Query has a functional language, called M, which is a data mashup language. There are many, many benefits to data preparation in PQ but some of them are: 1) one can easily use recursion in M (not possible in DAX), 2) standard operations like pivoting, data imputation, string manipulation, statistical functions, using ML algorithms are one-click (or almost one-click) operations in PQ, 3) columns calculated in PQ are much, much, much better compressed than columns calculated in DAX (which are not compressed at all). There are many more benefits but the above come to my head right away.
@Awollet33 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Also check:
https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://sqldusty.com/2015/08/10/cleaning-your-powerbi-power-query-code/
Appreciate your Kudos.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |