Pivot columns

[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. I need to pivot the monthly work hours (shown below) but they are not visible when I go to Edit Queries. Do I have to re-create both columns in the Query Editor in order to pivot them? If so, could you tell me how to create a concatendated column in Query Editor? It was super easy on the data table view but I can't figure it out in Query Editor.

[v-piga-msft]

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

[Anonymous]

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.

[v-piga-msft · Accepted solution]

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

[ImkeF]

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.