So I am trying to show the difference between revenue for this year and last year by week. I can calculate this easily enough but when I add it to my matrix the data does not work right. I am showing the data by company for the rows but it drills down to region and then yard. For the columns I have the week-year so that we can see them compared next to eachother. I want to be able to add a variance column, which would subtract the 2019 data for each week from the 2020 data for the same week. That would idealy only be after the current year but currently it shows up after both years, and even then it gives me 0's or is just replicating the number for that week. See below. I have tried creating both measures and columns and so far nothing as worked.
Sure so my dollar values, estimated revenue is measure that is the sum of the estimated revenue.
The column is one I created that takes the week the data falls into and combines it with the year so that we can compare each week of 2019's estimated revenue with each week of 2020's estimated revenue side by side. Being that I am only using 2 columns any measure that I create to give me a variance either is giving me a 0 or the number the number that is showing up for each of the weeks and sometimes it is positive and sometimes it is negative.
I created a prior year measure and linked to the calendar table and then created the variance using both the current prior year measures and that did not work either.
The raw data looks like this.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
