KPI with % change

Question

I am looking to build some KPIs with a % change from the most recent complete period (month or quarter) to a previous period (either previous quarter/month or same quarter/month from previous year), but everything I've found in the community and elsewhere online does not quite work. Here is an example of what I'm trying to achieve:

% change calculated with the formula: (Current Period - Previous Period) / Previous Period

One of the requirements is that these KPIs sit on the top of a dashboard with other components that show the entire 5 quarter timeframe, and that it dynamically will select the last complete quarter/month or the same one from last year when this is updated. The metric doesn't have to be in the same box as the % change, though.

I'm relatively new to PBI - but this was pretty straightforward in Tableau: make a table calculation for % change, then use a lookup function to look back 1 or 5 quarters, depending on input from a parameter switch. If anyone has some insight on how to think about this differently in PBI, it would be greatly appreciated.

amitchandak · Accepted Answer

Measure =
var _current = Switch( selectedvalue(Period[Period]) ,
"Month", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(('Date'[Date]))),
"Quarter", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date]))),
"Year", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date])))
)
var _prior = Switch( selectedvalue(Period[Period]) ,
"Month", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,Month))),
"Quarter", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER))),
"Year", QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year)))
)return divide( _current - _prior, _prior)
&nbsp;
refer
https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79
&nbsp;
https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

Forum Discussion

KPI with % change

2 Replies

Related content

Ranking KPI card

KPI Card Behaviour Changed?

KPI level matrix table

KPI CHANGE COLORS

New PBI KPI Card?