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
Hello community,
I need help with this:
Table 1 registers tasks of people for a specific job, but it registers only the current team:
Table 2 keeps track of historical allocated teams for a specific job:
I would like Power Query to change Table 1 base on table 2: In this example case June 30th handlig1 task for that job would replace mary Jones by John Smith. Is it possible?
Thanks in advance.
Link for the model: https://www.dropbox.com/s/i0iju0r60g322bs/Historical.pbix?dl=0
Solved! Go to Solution.
Hey,
I'm not sure if I understood your data model 100% but I used two columns for the Left Outer Join: fullJOB and Task
The changed file is here
After the I expanded the table and just selected the column
Rows in the base Table "Jobs" have not been duplicated ...
After that I created a custom column Team", but as far as I understood your requirement it would also been sufficient to take Initial Team column
Here is the result in the report
Hope this helps
Hey,
in the QueryEditor
Hope this gets your started
Regards
Thank you @TomMartens,
That was my initial approach. But the table expansion gets records duplicated. After that result I dont know how to replace the task team and delete the duplicates I dont need. Check the link of the model if you will.
Best Regards
Hey
what columns did you use for the join, were you expecting duplicate rows
yes: why
no: maybe a column is missing during the join
I will have a closer look at your model tomorrow.
Cheers
Hey you,
I used fullJOB for the join and I didnt expect duplicates.
Thank you for your time.
Hey,
I'm not sure if I understood your data model 100% but I used two columns for the Left Outer Join: fullJOB and Task
The changed file is here
After the I expanded the table and just selected the column
Rows in the base Table "Jobs" have not been duplicated ...
After that I created a custom column Team", but as far as I understood your requirement it would also been sufficient to take Initial Team column
Here is the result in the report
Hope this helps
Thank you @TomMartens,
My rookie knowledge wasnt aware of the possibility to link 2 columns in the merge step. That was the ace in the hole. next step: Go Live.
Best regards.
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 |