Forum Discussion

unicorns's avatar
unicorns
Icon for Helper II rankHelper II
3 years ago

MoM% calculation starting at 0%

Hello,

 

I have a simple MoM% calculation for revenue. I am starting with July 2022 and disabled any previous months from showing my bar graph, but the percentage starts with -100%. How would I change this to 0% to start from July 2022? 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    unicorns , Assume you have two measures current and last

    Switch(True(),

    isblank([Current]) && isblank([Last]) , blank() ,

    isblank([Last]), 0 ,

    divide([Current]-[last], [Last])  )