Comparing the top 5 days of this month to the top 5 days of this month last year.

[duggy]

Hi,

I have a list of the top 5 days this month. I need to compare it to the top 5 days of last year this month. To get the top 5 days of this month is simple, I have a table visual and order by top actvity and then add a filter to restrict to 5. How would I then add last year's top 5 days for this month next to it and then compare the growth between the two?

Much appreciated.

[Ashish_Mathur]

Hi,

Share some data and also show the expected result.

[v-yuta-msft]

@duggy ,

You may create a measure using DAX like pattern below:

Last Year Same Month =
TOPN (
    5,
    FILTER (
        Table,
        YEAR ( Table[Date] ) = YEAR ( TODAY () )
            && MONTH ( Table[Date] ) = MONTH ( Table[Date] )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.