Forum Discussion

BishwaR's avatar
BishwaR
Icon for Helper V rankHelper V
5 years ago
Solved

How to convert this DAX in power query

I have a measure as given below

New Date = IF (PO Date > Ship Date,PO Date,IF(Ship Date > PO Date,Ship Date),IF(PO Date = Ship Date,PO Date))))

 

Now I need to convert this DAX into power query.

 

Please Help

 

Thanks

Bishwa

Need Help

5 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion
    5 years ago

    BishwaR  - Your Dax can also optimised 

     

    New Date = IF (PO Date >= Ship Date,PO Date,Ship Date)

     

    If this post helps, then please consider Accept it as the solution and give it a thumbs up

    • BishwaR's avatar
      BishwaR
      Icon for Helper V rankHelper V
      5 years ago

      Thanks but how can I implement the if condition.

      If PO Date is > Ship Date then PO Date

      if Ship Date > PO Date then Ship Date

      If PO Date = Ship Date then PO Date

       

      Thanks

      • BishwaR's avatar
        BishwaR
        Icon for Helper V rankHelper V
        5 years ago

        I figured it out Your solution just worked perfect Thanks again