Forum Discussion

AUS2029's avatar
AUS2029
Regular Visitor
7 years ago
Solved

Calculated Columns disappeared after Append Queries

I have three tables with added in calculated columns. ( two had same columns/ heading, one has some same columns/headings with the other 2).  The purpose is to combine these three tables into one. S...
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    DAX formulas (calculated columns or measures) will not be visible in the QUery Editor.  Therefore, you should first append data from th 3 tables, run the Unpivot tansformation step.  Click on Close and Apply and then write your LOOKUPVALUE() function.

AUS2029's avatar
AUS2029
Regular Visitor
7 years ago

Thanks v-chuncz-msft. Just tried Union and Selectcolumns to create a new table. I can view this new Table under FIELDS, but when under Edit Queries, this new table does not show. And I also realised that some other new tables created by Selectcolumns & Union are not showing under Edit Queries environment.