Forum Discussion

Helper I

1 year ago

Solved

Trend calculation in matrix by year

Ashish_Excel
1 year ago
The visual calc measure would be
Versus previous = format(divide(([OP Amt/Service] - PREVIOUS([OP Amt/Service])),PREVIOUS([OP Amt/Service])),"percent")
Hope this helps.

Solution Supplier

1 year ago

Hi,

Modify the measure to

Measure = if(min('Calendar'[Year])=year(today()),BLANK(),DIVIDE(([OP Amt/Service]-[OP Amt/Service PY]),[OP Amt/Service PY]))

Hope this helps.

Helper I

1 year ago

I see you have a new measure called OP Amt/Service PY, I assume that's the "prior year". can you share that one as well? or the PBIX file. Thanks

Ashish_Excel
Solution Supplier
1 year ago
In my mailed dates May 23, i had already shared the file with you.