Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
As the sample example below shows, i have 2 separate excel files with identical columns, with the right most column being added as a calculated column in PBI power query. I need to create a table in PBI looking like the one on the right.
I am pretty new to PBI so as much detail as possible is appreciated.
thanks in advanced
Solved! Go to Solution.
Used the following tutorial at the end, Thank you for your input.
https://www.youtube.com/watch?v=qXH4WjCykLc&ab_channel=RADACAD
Used the following tutorial at the end, Thank you for your input.
https://www.youtube.com/watch?v=qXH4WjCykLc&ab_channel=RADACAD
Since you already have a Financial Year column in both, just rename the last column to "Total" in both queries. Then you just need to append the two queries to get your output. Don't forget to right click on the two source queries to uncheck "Enable Load" so that only your final query is loaded.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Power BI doesn't let me name that column on both tables "Total". I renamed the column to "Total" on the one table, and when i try to rename the column to "Total" on the other table it says "The name 'Total' is already used for a measure on table 1. Choose a different name.'
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |