Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX help

I have one scnario, First case, If the Sales Order number is same, customer reference number is different, then sum of sales order quantity. Second case, if the sales order number is different, and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago

Hey Anonymous,

 

Thanks for sharing, but it is still not very clear from the conditions you have mentioned and the output you are looking for. How you are arriving at the Output ?

 

Cheers!
Vivek

https://www.vivran.in/

Connect on LinkedIn

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    IF the Sales Order is same and Customer reference is same, then I took sum of quantity. (Here Customer reference number is Purchase order id only) IF the Sales Order is different and Customer reference is same, then I took maxquantity. (If we failed to deliver Sales Order quantity, then we will create another Sales Order for remaining quantity). So my requirement is to show quantity item, item-variant and customer level. Please help