I am a beginner to Power BI and really appreciate your help.
I have 20 offices. Each office has 5 units and each unit has 3 sub units.
I set up the following lookup tables:
Office - office #, city, state, region
Unit - Unit # and Sub #
The Office lookup table works and slices and dices all the information correctly. The unit table does not work.
I made another table:
Org - Org #, Office #, Unit #, and Sub #
The org table connected to the Office table and the Sub table but will not connect with the data table. I get a many to many error although each org in the look up table is unique.
Thank you for your help!
I have 20 offices. Each office has 5 units and each unit has 3 sub units.
I set up the following lookup tables:
Office - office #, city, state, region
Unit - Unit # and Sub #
The Office lookup table works and slices and dices all the information correctly. The unit table does not work.
I made another table:
Org - Org #, Office #, Unit #, and Sub #
The org table connected to the Office table and the Sub table but will not connect with the data table. I get a many to many error although each org in the look up table is unique.
Thank you for your help!
