Power BI: Revenue Prior Year

2021-02-24T09:33:25.76+00:00

I am doing the comparison of current revenue with prior year values.

For the current year I am using the following formula:
Current year = SUMX(FILTER(REV_IFRS_15, REV_IFRS_15[REPORTING_YEAR] = [REPORTING_YEAR]), REV_IFRS_15[COST_REWARD])

What is the correct syntax for the prior year values?

I am also using slicer for the reporting years. So if for example I choose "2020" on slicer I expect to have 2020 as the current year revenue, and 2019 as prior year revenue.

Thanks!

Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
685 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful