Measure to show figures for matching periods year on year periods,

Hi,
Sorry not very clear ,

I want to compare the Current and previous years for the months that they both have figures for,

2020 = March -Dec

2021 = Jan - July = Current = March - July , Previous = March - July

2022 = Feb - July = Current = Feb - July Previous = Feb - July,

So otherwise in the 2020 / 21 comparison you would be comparing a 2021 total of Jan - July against a previous total which was only Mar - July.

so in the attachments a total of 2021 = 84 overall total but if for months that correspond to the 2020 it now = 62 as it does not include jan and feb as there are no figurs for comparison year 2020.
I have re attached an highlighted the two differing totals and the measure new current total hope this makes it clearer if not at least it's what I was looking for if not the best way of doing it.

Richard

Thanks, I'll have a look I might try Mr excel and mark this up, I found a couple of ways to get the month level, also I have a quetion re the first of month measur I wanted to use, I have shown it in the attachment but could not use it as it returns a 01/01/1900 when no values are present, it's proabably best to have look rather than me describe; the measure is EON_FNB, I use EOMONTH(_,-1)+1, as I did not know there was a start of month
which works better.

using the ammeded prevoius year ;

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

or just;

Please Login or Register  to view this content.

Richard