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.
If it is convenient, could you share some data sample and your desired output so that we could help further on it?