Can a KPI calculate the "distance" related to previous month instead of the goal?

[WorkHard]

Currently, the Distance in the KPI has three options:

Value, Percent, or Value and Percent.

By default, PowerBI calculates the distance as it's related to the goal which in my example is 90%.

Instead, I'd like the distance to be based on the previous month's value.

Let's say if the previous month was 50% and this month is 100%, I'd expect the distance to say 50% increase.

Is this possible?

[V-pazhen-msft · Accepted solution]

@WorkHard 
Lets say if you have a common date column, you can add the previous month distance to your test measure.

new measure = [test measure] + calculate(sum([distance]), filter(allselected(table), [date].[month.no] = max([date].[month.no])-1))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.