Forum Discussion
Pivot columns
Hi Anonymous,
It seems that you created the calculated columns with dax expression in Data view.
Actually, we cannot see the calculated column in Editor Queries. We could see the custom columns created in Query Editor.
There is something different between calculated column and custom column.
In addition to the difference of language used to create them, there are also others different parts between them.
We could take a look at the article Calculated columns in Power BI Desktop, which explains the main difference between those two columns.
If you want to pivot the monthly work hours in Query Editor, you need to create the custom columns in Query Editor.
Best Regards,
Cherry
Hi Anonymous,
I created a custom column for monthly work hours. I also created a custom column to concatenate 3 columns into one with a hyphen as a separator between text strings.
Did you create all of the columns in Query Editor? And you cannot see the columns when I go to Edit Queries?
If it is convenient, could you share the screenshots about the Applied steps in Query Editor?
Best Regards,
Cherry
The concatenate column for Contractors and the Monthly Remaining Hours were all created using custom column in the Data view and not in Query Editor.
Hi Anonymous,
It seems that you created the calculated columns with dax expression in Data view.
Actually, we cannot see the calculated column in Editor Queries. We could see the custom columns created in Query Editor.
There is something different between calculated column and custom column.
In addition to the difference of language used to create them, there are also others different parts between them.
We could take a look at the article Calculated columns in Power BI Desktop, which explains the main difference between those two columns.
If you want to pivot the monthly work hours in Query Editor, you need to create the custom columns in Query Editor.
Best Regards,
Cherry
In the query editor, go to "Add Column" -> Custom Column. This will allow you to reference the (rows from each) column just like in the data view.
You can also try "Add Column" -> Column From Example instead. There you fill in the desired result of some rows and the engine will try to find out the correct syntax by itself.
