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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mdrammeh
Helper III
Helper III

My Data Dilemma with Power Query & Power BI

Hello Everyone,

I have three sets of tables to complete a material order.

The first table includes the project number (Proj #), description, schedule start date, and expected delivery date. Each project number has more than three design codes

The second table consisting of the design code includes the quantity of design complete for each design code. For each design work complete, there are multiple material id’s associated with each design code.

The third table consisting of the material code includes the metric units per material order expressed in feet, count of units, assembly etc.

As a result, my query is returning a many-to-many or one-to-many relationship error. I have watched and researched several videos online and read different articles but none of them have proofed to be helpful now.

Therefore, I was hoping that someone on this forum might have a better understanding to help me understand and resolve this problem in (1) Power Query, (2) PowerPivot, and (3) Power BI.

If needed, I can e-mail you sample data or post a few example later to give you an example scenarion

Thank you.

Mustic

1 REPLY 1

Hi,

 

I ran a session on Many to Many in DAX a few weeks ago: https://www.youtube.com/watch?v=TE7MT9P6k8M

I am covering the following topics : DAX, Power Query, Data Modelling.

 

Tell us if it helped you !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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