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

1 Reply

  • 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