Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table of dates, units (~990 variations) and depts (~150). What I think I need is all of the dates, then for each date, the units, then for each unit the depts. So I'd end up with 6/8/2021, unit 1234, DEPTS 0010 0020 0030, then 6/8/2021 unit abcd, DEPTS 0010, 0020, 0030. I've tried append and merge but there are no commonalities to support the duplication.
The real end result that I'm trying to find a solution for, is I have a list of like below that I need to systematically re-distribute.
DATE | UNIT | DEPT-WC | HOURS |
6/8/2021 | 12345 | 0010-01 | 5.0 |
6/8/2021 | 12345 | 0011-01 | 5.0 |
6/8/2021 | 12345 | 0012-01 | 20.0 |
Unit 12345 needs to zero out, which I was able to achieve with another added column as i need to do certain percentages for certain units, but the challenge is I need to take 45% of 12345 and add it to unit 23456 and 55% and add it to unit 34567. The receiving units do not have the dept-wc combination on this table. I've tried a summarize table, which I can get it to do the math across, and show me what should go to unit 1, unit 2, but then I cannot get the math to add it back into the measure properly to the correct unit-dept combination (can drop off the wc)
Can you please share a snapshot of the source data? Is the source data, same structure but multiple tables or different tables that need to be linked together?