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
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.
