How to do YoY comparison broken down by month with COUNT calculation?

[Anonymous]

Hello Community!

Hopefully someone can rescue me on this one! 

I have data like this:

Date	Full Name
12/08/2022	Ms Vicky Castillo
17/03/2021	Mr Mark Molloy
05/01/2022	Ms Michaela Synnott
09/10/2021	Ms Heli Mooney
05/08/2021	Mrs Karen Herbert

I would like to COUNT how many people there are for each month (I don't care about the day or time, exactly) and then display this on a bar chart. 
However, this bar chart needs to also display a bar chart for each month, but for the previous year! 
I want to see how many people there are, for example, in January 2022 and at the same time how many there were on January, but of last year. 

Eventually, I would get something like this:

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could create two measures .I tested a simple file:

Total sales LY = CALCULATE(SUM(financials[ Sales]),FILTER(ALL(financials),EOMONTH([Date],0)=EOMONTH(MAX('financials'[Date]),-12)))

%change = DIVIDE(SUM([ Sales]),[Total sales LY])-1

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[davehus]

Hi @Anonymous ,

Are you looking for something like new or returning customers? If so @marcorusso has a great blog on this. See link below. DAX Patterns: New and returning customers - SQLBI

D