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

It's Power BI. Below are steps that has taken so far.

  1. get data from excel
  2. add columns using LOOKUPVALUE from a separate table
  3. repeat above for other two tables
  4. Use Append Queries to append three tables which had added columns created from LOOKUPVALUE

 

Next planned steps after combined/append three tables together

  1. Edit Query
  2. Select columns then Unpivot columns

the issue I am facing is, the added columns are not showing under Edit Query Table. therefore cannot Unpivot columns.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.