Forum Discussion
Jalal_1988
Oct 31, 2023Brass Contributor
Dax or Power Query
Hello my friends please i have problem, how I can move the excel formula in yellow color area to power query or DAX?
Lorenzo
Nov 03, 2023Silver Contributor
Hi Jalal_1988
After fixing the date (in m/dd/yyyy format) issues in your file and refreshing your pivot table:
Attached Power Query + Power Pivot:
So this looks good. However, there's a problem of logic in your Excel formula for Performance:
// Peformance formula:
=IF(E5=D5, "New Order",
IF(E5>C5,
IF(D5=0, "Need to place order or increase the deposite",
IF(E5=0, "Contact the customer to place order",
IF(D5>E5, "Good performance and continue cheecking",
IF(-C5>E5,"Push to place new order", "Reevaluate the performance")
)
)
)
),
"MISSING argument here"
)
Didn't try to fix it in the corresponding Power Query formula - it'll return: *** DON'T KNOW ***...