Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX error

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 value...
Get Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    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).