Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF Statement taking too long to execute

Hi,   I have created a multiple IF statement but the statement is taking too long to execute, is there a way around this? My measure: Trend = IF([Count Negative Results] = 6, "Losing", IF([C...
Need Help
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Have you tried making a call the measures and storing as variables outside of the IF/SWITCH ?

 

Trend = 
var __CountNeg = [Count Negative Results]
var __AvgMov = [Average Moving and CY TTM]

RETURN

SWITCH(TRUE(),
__CountNeg = 6, "Losing", 
__CountNeg in {3,4,5} && __AvgMov <= -.6 ,"Losing", 
...

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Worked like a charm! Thank you all!

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    Hey Anonymous,

     

    please mark the most helpful post as an answer, as it also helps others in this forum.

     

    Regards,

    Tom