Forum Discussion

BIanon's avatar
BIanon
Helper V
3 years ago
Solved

Basic Index measure question

Hello Community,

I am trying to create a versus LY index measure.

Currently I am doing

 

DIVIDE(measure, measure LY, 0) - 1

 

Percentage format.

But if I do this, rows with no data gets populated by a '1' meaning I get useless data points in my visualisations.

I would like the measure to just show change in percentage in relation to last year.

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    BIanon , You can try


    if(isblank([measure LY]), blank(), DIVIDE([measure], [measure LY], 0) - 1)

     

    or

     

    DIVIDE([measure]-[measure LY], [measure LY])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    BIanon , You can try


    if(isblank([measure LY]), blank(), DIVIDE([measure], [measure LY], 0) - 1)

     

    or

     

    DIVIDE([measure]-[measure LY], [measure LY])