Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
AUS2029
Regular Visitor

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. So, used Append Queries. But the result did not include any Calcuated columns. 

PS. the added columns are result of LOOKUPVALUE. 

how to resolve this?

1 ACCEPTED SOLUTION

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
v-chuncz-msft
Community Support
Community Support

@AUS2029,

 

You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

LivioLanzo
Solution Sage
Solution Sage

Hi @AUS2029

 

If I understand correctly, you're performing the 'Append' within Power Query and then adding the calculated column with DAX. 

You need to do the appending, load the data into the model and then add the calculated column

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

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.

 

 

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.