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.
Hello!
I have appended Table 2 (contains calculated TV programme ratings from one TV channel) to 'master' Table 1 (contains TV programme ratings from many TV channels). Although data from all fields append normally, I cannot get the ratings figures from the calculated column in Table 2 to show in the appended table.
I have used the same column name, but I guess the issue is that the calculated column is not available in the Query Editor, hence the numbers are not transferring through.
Is there a painless way to get the figures from Table 2 to transfer to Table 1?
Many thanks in advance,
George.
Solved! Go to Solution.
@Anonymous Unfortunately the only way currently is to create new calculated column in table 2.
Thank you both for your responses. I'll live in the hope that Microsoft will enable this some time soon!
@Anonymous Unfortunately the only way currently is to create new calculated column in table 2.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |