Forum Discussion
Compare Against Previous Period KPI Card
Hi All,
I want to be able to use a regular metric in my given date filter and create a KPI card that will show percentage % increase or decrease from the previous period of the selected period. Is this possible? I don't see a compare against previous period or date range?
Thanks!
You can use the PARALLELPERIOD() function https://learn.microsoft.com/en-us/dax/parallelperiod-function-dax - something like CALCULATE([Current Period Measure], PARALLELPERIOD([Dates], -1, YEAR)).
Or even the DATEADD function (https://learn.microsoft.com/en-us/dax/dateadd-function-dax)
If your users need to be able to select a specific time period that isn't an set number of days - you can follow the method in the SQLBI article: https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
4 Replies
vicky_Super User
You can use the PARALLELPERIOD() function https://learn.microsoft.com/en-us/dax/parallelperiod-function-dax - something like CALCULATE([Current Period Measure], PARALLELPERIOD([Dates], -1, YEAR)).
Or even the DATEADD function (https://learn.microsoft.com/en-us/dax/dateadd-function-dax)
If your users need to be able to select a specific time period that isn't an set number of days - you can follow the method in the SQLBI article: https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
HI,Anonymous
Excuse me, was his answer helpful?
If it's helpful, you may consider marking vicky_'s answer as a solution, so that community members in the community who have similar questions to you can find the answer more quickly.Thank you in advance for your contribution to the community.
Best Regards,
Leroy Lu