Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have appended the query multiple times and I did not seem to have any issue, until now.
Thats the formula I used, I am not sure what the problem is.
There are no duplicate values. I double checked and it is still throwing error.
Any help is appreciated!
Thank you!
The error implies that 'Part File' contains multiple rows where 'Part File'[PartPlantbyYearWeekNum] is the same but has different values of [OrderMinimumQty].
Try defining a calculated table like this to try finding where this occurs:
Summary =
FILTER (
SUMMARIZE (
'Part File',
'Part File'[PartPlantbyYearWeekNum],
"DistinctQty", DISTINCTCOUNT ( 'Part File'[OrderMinimumQty] )
),
[DistinctQty] > 1
)
Thank you! @AlexisOlson
This is the result I got:
I dont see the partplantbyYearWeekNum being repeated.
I still quite not understand what the problem is.
I understood what the problem is.
PartplantByYearWeekNumber is repeated twice with different orderminqty.
Thank you! @AlexisOlson
Can I please know how to fix that?
Thanks again!
You need to either remove the repeats before loading the query to the model or else decide how you want to choose Qty when there are multiple values present and write your lookup accordingly (not with LOOKUPVALUE).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |