Is there a way to make calculated columns show in the Query Editor?

[Anonymous]

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.

[MFelix · Accepted 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

[MFelix · Accepted 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

[Anonymous]

Thank you for that clarification, @MFelix. So will DAX formulas not work at all in the Query Editor?

[MFelix · Accepted solution]

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

[RMDNA]

There is not, as far as I'm aware, because calculated columns are fundamentally different from columns created in the Query Editor.

[Anonymous]

Thank you, @RMDNA. Sad day, but I appreciate the clarification.