Forum Discussion

pankajj's avatar
pankajj
Icon for Helper III rankHelper III
6 years ago
Solved

Need Help to Auto populate Shipping Delays Message in Power Query

Hi Team of Experts!   I need help in displaying Stock Alert.   My data sample and expected result is as follows:   ORDER-LINE ORDER QTY Demand_Order ALLOTTED_QTY QTY_DIFFERENCE PROMISE ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    pankajj 

    With You got cal remaining, Changed logic. You need add early and late logic

    Message = if(not(ISBLANK('Table'[ORDER QTY])) && [TOTAL_SHIPPED_QTY]>=[ORDER QTY]
, "FULL QUANTITY SHIPPED" ,
	if(not(ISBLANK([Supply_Date])),
		if([QTY_DIFFERENCE]>0
		&& [Cal remaining]=0 ,  "Full Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE] ,
			if([Cal remaining]>0 && [QTY_DIFFERENCE]>0 ,
				"Partial Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE] ,
					if([Cal remaining]>[ALLOTTED_QTY] && [QTY_DIFFERENCE] = 0 ,
						"Final Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE]

, "NO SUPPLY DATE")

))))
pankajj's avatar
pankajj
Icon for Helper III rankHelper III
6 years ago

amitchandak 

Hi Amit,

Sorry to bother again.

I'm sure being a super user, i will be pretty quick for you.

Can you please suggest the way to calculate REMAIN_QTY.

Thanks a ton for all your patience and help so far.

You guys are doing a excellent job for the community.

Best regards,

Pankajj

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

pankajj 

With You got cal remaining, Changed logic. You need add early and late logic

Message = if(not(ISBLANK('Table'[ORDER QTY])) && [TOTAL_SHIPPED_QTY]>=[ORDER QTY]
, "FULL QUANTITY SHIPPED" ,
	if(not(ISBLANK([Supply_Date])),
		if([QTY_DIFFERENCE]>0
		&& [Cal remaining]=0 ,  "Full Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE] ,
			if([Cal remaining]>0 && [QTY_DIFFERENCE]>0 ,
				"Partial Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE] ,
					if([Cal remaining]>[ALLOTTED_QTY] && [QTY_DIFFERENCE] = 0 ,
						"Final Quantity" & "(" & [ALLOTTED_QTY] & ")" & " Arriving on" & " " & [Supply_Date] & " " & "for" & [ORDER-LINE]

, "NO SUPPLY DATE")

))))