Forum Discussion

jbarnard2's avatar
jbarnard2
Frequent Visitor
2 years ago
Solved

KPI with % change

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), ...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

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)

 

refer

https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79

 

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

jbarnard2's avatar
jbarnard2
Frequent Visitor
2 years ago

thanks for the quick reply! Maybe I don't understand how these functions work, but I need entire previous quarters, not quarter or month to date.