Forum Discussion
Dynamic Fiscal Year Calculation
Anonymous
Thank you for your reply! Your method works on most dates, but when you choose any day in April, it shows only April and May. Please help!
Hi brankocareer
After my test, this is because the sample data you provided only has data up to May of 24. I added data from later dates to the data, and the results are as follows:
Output:
In addition, I found that the newly created slicer table needs to be modified to a continuous timetable.
Slicer = CALENDAR(DATE(2019, 1, 1), TODAY())Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thank you for your reply! Your method works on most dates, but when you choose any day in April, it shows only April and May. Please help!
Hi brankocareer
After my test, this is because the sample data you provided only has data up to May of 24. I added data from later dates to the data, and the results are as follows:
Output:
In addition, I found that the newly created slicer table needs to be modified to a continuous timetable.
Slicer = CALENDAR(DATE(2019, 1, 1), TODAY())
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.