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.
I have created two calculated columns in the default Data view because I like creating my DAX formulas with the Intellisense suggestions. However, I cannot see or use said columns in the Query Editor. Is there a way to show calculated columns in the Editor view? I don't like the idea of having to create them all at the Query level.
Solved! Go to Solution.
Hi @Anonymous,
Regarding your question the first thing you need to be aware is that the query editor uses M language to make the treatment of the information and the Data View of the PBI is on DAX, this are two different languages with very different syntaxes so with different ways of working the information.
Based on this as you cannot see all the steps you have on the query editor on the Data view you can't also see the calculated measures or columns created in DAX in the query editor. They are separated from each other and have different purposes within the PBI.
Query Editor to clean, shape and transform the data from a data source for getting data.
Data View to model the imported data and define calculations for analytics.
You don't need to create everything on the query view or on the Data view it depends on your objectives and data model somethings, can be made in one and some in the other depends on your requisites.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
No DAX formulas don't work on the query editor as M formulas don't work on the Data view it's different concepts.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
Regarding your question the first thing you need to be aware is that the query editor uses M language to make the treatment of the information and the Data View of the PBI is on DAX, this are two different languages with very different syntaxes so with different ways of working the information.
Based on this as you cannot see all the steps you have on the query editor on the Data view you can't also see the calculated measures or columns created in DAX in the query editor. They are separated from each other and have different purposes within the PBI.
Query Editor to clean, shape and transform the data from a data source for getting data.
Data View to model the imported data and define calculations for analytics.
You don't need to create everything on the query view or on the Data view it depends on your objectives and data model somethings, can be made in one and some in the other depends on your requisites.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you for that clarification, @MFelix. So will DAX formulas not work at all in the Query Editor?
Hi @Anonymous,
No DAX formulas don't work on the query editor as M formulas don't work on the Data view it's different concepts.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThere is not, as far as I'm aware, because calculated columns are fundamentally different from columns created in the Query Editor.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |