Forum Discussion

AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

This looks fairly clean already. That said, you could try replacing your MAXX with a LOOKUPVALUE. That is,

VAR _ConversationRate =
    SWITCH (
        _currency,
        _currencySelected, 1,
        LOOKUPVALUE (
            'Exchange Rates'[Exchange Rate],
            'Exchange Rates'[From Currency], _currency
        )
    )

 

Can you pinpoint what part is slow? Try replacing _Onhand_StdCost, _PickedQty, and _ConversationRate with a constant (e.g. 2) one at a time to see which one(s) are slowing it down.

 

  • Mohan128256's avatar
    Mohan128256
    Helper IV
    2 years ago

    AlexisOlson  thanks for the reply. Appreciate it.

     

    I tried this earlier..but it made more complicated than earlier.

    I will try to dig it out by your suggestion.

     

    Thanks,

    Mohan V.

    • Mohan128256's avatar
      Mohan128256
      Helper IV
      2 years ago

      AlexisOlson Greg_Deckler 

       

      When i run the both Onhand StdCost+PickedQty it took hardly 2 sec.

      But then when i added the multiplication with conversionrate it is taking more time like almost 30+ sec.

      I believe it is because of the switch case that i am using in here.

      Not sure how can i make it quick.

      Any suggestions please.

       

      Thanks

      Mohan V.