Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a table DIM_Salaries from wich a delete duplicate (verify under Excel)
I link it to a fact table FTS_Heures, but it doesnt want a one to many ......
here my file
https://1drv.ms/u/s!AoqtZHsX4BzvhL4Cmhkus3rE_JjUIg?e=c8J7nc
Solved! Go to Solution.
hello based on what you sent , it seems you have duplicates therefore , a many to many relationship , but it seems you have a duplicate in your dim salary table
so maybe just remove duplicates or create a new table
Values = VALUES(dim_salaries[id])
here is your duplicate
hi
thanks to your screenshot
i found the error
a space in one of the case
have a nice day
Hi thanks
But in the Power Query transformation i have remove duplicate
That is why i don't understand
Thats weird did you select all columns and pressed remove duplicates? Maybe you have the same id but it has different dimensions in the column
hello based on what you sent , it seems you have duplicates therefore , a many to many relationship , but it seems you have a duplicate in your dim salary table
so maybe just remove duplicates or create a new table
Values = VALUES(dim_salaries[id])
here is your duplicate
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |