Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Pivot columns

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.

 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        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