Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi,
Share some data and also show the expected result.
@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.
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |