How to Append multiple tables with calculated column

[Anonymous]

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

[Greg_Deckler · Accepted solution]

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

[Anonymous]

Hi @Greg_Deckler 

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

[Greg_Deckler]

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

[Anonymous]

Thanks a lot  @Greg_Deckler , I have figured it out. I was actually creating the custom column form desktop not Edit Queries....had brain freeze ...lolz 

[Greg_Deckler]

No worries @Anonymous ! I was thinking that was the case but you seemed very adamant about it!! 🙂