Power BI: Revenue Prior Year

Question

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!

Answer 1

Hello,

Power BI related questions are not supported on this forum. It's better to reach out to dedicated forum over here:

https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav