Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Please verify that you added the calculated columns in the Query Editor and NOT in Power BI Desktop after the queries ran.
Please verify that you added the calculated columns in the Query Editor and NOT in Power BI Desktop after the queries ran.
OK, can you post the Advanced Editor output for all three of your queries?
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
No worries @Anonymous ! I was thinking that was the case but you seemed very adamant about it!! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |