Forum Discussion
Mohan128256
Helper IV
Helper IVNeed help in optimizing DAX query
Hello All, I have written below dax which is taking 30+ sec of time to execute and produce the results. _InventoryAmtConversed =
VAR _Onhand_StdCost =
CALCULATE(SUM('Inventory Snapshots'[O...
Mohan128256Helper IV
Helper IVAlexisOlson 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.
Mohan128256Helper IV
Helper IV
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.