Power Query / Power pivot : M2M relationships problem

Anything related to PowerPivot and DAX Formuale
almourasel
Posts: 2
Joined: Wed Jun 10, 2020 11:53 pm

Power Query / Power pivot : M2M relationships problem

Postby almourasel » Thu Jun 11, 2020 12:03 am

Hello colleagues.

i am new with power query and power pivot , i have a request to support me to finish a file that i have to use it to trace.
what i need it to have a pivot table that show below info per week :

1- Week
2- Sales
3- Forecast

for example : W10 => sales 1000 pcs / forecast 1200 pcs .

later i will need to add other table which is the car production per week per family.

i attach an example for first try ( it contain the structure of my request and first try without considering car build in the file ).

as you can see in the below print screen from excel file that when i try to match the weeks number from table ( week ) with sales info from ( sales ) and forecast info from ( forecast ) , the same number appear for all weeks and an error appear as there is no relationship.
Attachments
error.PNG
error.PNG (61.65 KiB) Viewed 287 times
structure.PNG
structure.PNG (32.64 KiB) Viewed 288 times
New folder.zip
(235.75 KiB) Downloaded 4 times

almourasel
Posts: 2
Joined: Wed Jun 10, 2020 11:53 pm

Re: Power Query / Power pivot : M2M relationships problem

Postby almourasel » Thu Jun 18, 2020 1:00 am

HI colleagues

is there any additional info i have to add ?


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests