Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kmes912
Helper I
Helper I

Creating Table Using Other Tables

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. 

 

 

DATEUNITDEPT-WCHOURS
6/8/2021123450010-015.0
6/8/2021123450011-015.0
6/8/2021123450012-0120.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)

1 REPLY 1
Anonymous
Not applicable

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.