Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day everybody!
I am working on a project to show the total sales per year.
For this, I have a slicer with the years: 2016, 2017 and 2018.
When I select one, I must show the last month registered in each one, for example in 2016 (September), 2017 (December) and 2018 (October).
Which formula can I use to detect the last month for each year?
So far I could only do it for 2018, using the following formula:
ThisMonth = IF ([Date] = MAX ([Date]), "Y", "N")
But when I select 2016 or 2017 in the slicer, my sales table goes blank.
Thanks for your contributions.
Hi @odalistt,
If it is convenient, could you share some data sample and your desired output so that we could help further on it?
Best Regards,
Cherry
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |