Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@BIanon , You can try
if(isblank([measure LY]), blank(), DIVIDE([measure], [measure LY], 0) - 1)
or
DIVIDE([measure]-[measure LY], [measure LY])
@BIanon , You can try
if(isblank([measure LY]), blank(), DIVIDE([measure], [measure LY], 0) - 1)
or
DIVIDE([measure]-[measure LY], [measure LY])