Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Append multiple tables with calculated column

Hi Everyone,Hope you can help me with this one 

 

I have multiple tables with same column header with the different cell velues for the same items (Items are in the left most column). In the tables i have added Custom Calculated columns through Edit Queries in BI Desktop. But when I append queries the custom calculated column dont show up in the table.

 

what I want is combining all the tables in one table with the value from calculated column, is it possible??

 

 

 

 

Thanks in advance

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Please verify that you added the calculated columns in the Query Editor and NOT in Power BI Desktop after the queries ran.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    Please verify that you added the calculated columns in the Query Editor and NOT in Power BI Desktop after the queries ran.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Greg_Deckler 

       

      I have added the Custom Calculated column through Edit Queries in BI Desktop 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        7 years ago

        OK, can you post the Advanced Editor output for all three of your queries?