Basic Index measure question

[BIanon]

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.

[amitchandak · Accepted solution]

@BIanon , You can try

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

or

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