I am currently having a look at the Financial Reporting with Power BI course with regards to the Income statements & Prior Year Values
Please find attached a pbix file
There are 2 tabs - a Matrix tab which shows rows relating to Revenue/Gross Profit & Net Profit for 4 years and an Income statement tab which has 2 columns. One for Current Year and the 2nd for Prior Year
Please see further information below:
when I select 2018 in the Date Slicer, I see both columns for 2018 being the current year and 2017 being the prior year.
However the numbers for 2017 are not accurate when I select the 2018 Year slicer eg Current Revenue in 2018 is $34,843 and Prior Year (2017) shows $37,872 (which is incorrect)
when selecting 2017 in Date Slicer - the Revenue numbers for 2017 is $56,566 and 2016 is $56,929
Similarly when selecting the Year 2016, Revenue numbers are $56,929 & $57,654 and its also correct for 2015
Question - when selecting 2018 using the date slicer, why is the prior year number for 2017 not accurate?