Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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.
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
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.
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.
Next planned steps after combined/append three tables together
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |