Forum Discussion

Jalal_1988's avatar
Jalal_1988
Brass Contributor
Oct 31, 2023

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? 
power bi
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 03, 2023

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

Resources