Forum Discussion

JajatiDev's avatar
JajatiDev
Helper II
4 years ago
Solved

Excel Formula to DAX

Hi, I have the following excel formula, that retains the following values;   Allocated Pending Allocation Partial Allocation In Production   IF(OR([status]="Production",[status]="FactShipped"...
Need Help
  • JajatiDev's avatar
    JajatiDev
    4 years ago

    Hi,

    I was able to replicate the formula.

     

    Order Status =
    IF(OR('Orders'[status]="Production",'Orders'[status]="FactShipped"),"In Production",
    IF(AND('Orders'[delivery_type]="Ship as available",'Orders'[order_qty]='Orders'[confirmed_qty]),"Allocated",
    IF('Orders'[delivery_type]="Ship as available" && 'Orders'[confirmed_qty]>0,"Partial Allocation",
    IF('Orders'[delivery_type]="Full order consolidation" && SUMX(FILTER('Orders','Orders'[order_no]=EARLIER('Orders'[order_no])),'Orders'[order_qty])=SUMX(FILTER('Orders','Orders'[order_no]=EARLIER('Orders'[order_no])),'Orders'[confirmed_qty]),"Allocated",
    IF('Orders'[delivery_type]="Full order consolidation" && SUMX(FILTER('Orders','Orders'[order_no]=EARLIER('Orders '[order_no])),'Orders'[confirmed_qty])>0 ,"Partial Allocation",
    "Pending Allocation")))))
     
    Now the next step for me is to code this in M Language.
     
    Thanks,
    Dev
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey JajatiDev ,

 

Power BI is not Excel.

What do you want to do? Add column? Create a measure? What should the SUMIF represent? The sum on a row level? The sum for a specific column?

 

Please tell us how your table looks like and what you want as a result and then it's easier to help you.

 

Best regards

Denis

  • JajatiDev's avatar
    JajatiDev
    Helper II
    4 years ago

    Hi,

    Yes, I do acknowledge Power BI is different from Excel.

    All that I am trying to achieve is to add a column in the report replicating the excel formula to retain the text value.

     

    Thanks and Regards,

    Jajati Dev