Forum Discussion
Custom Date drop down slicer
Can you not simply add additional attributes to your existing Date Dimension table. Like attribute for Fiscal Year, Fiscal Quarter, etc. Then set up a Hierarchy in that Date Dimension of the Fiscal Year/Quarter/Month/Date.
Oh, and we really don't need to tag you in replies. You should get notifications of any replies regardless 🙂
Hi sid-agarwal
To achieve a wanted filtering functionality you need 2 things :
1. Fiscal calender , there are many guides of how to create it , for example :
https://www.youtube.com/watch?v=Lt_nNLQz0IE&t=7s2. To add a column to the created column which will check if the date is in current fiscal year and if yes it will giive a text "Current fiscal year" if no the original fiscar year.
The guide for creating the needed logic :
https://www.youtube.com/watch?v=um0dTXZhuekjust adopt it for your fiscal year calender
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 I will watch the videos, thank you. Will post any questions if I have after watching.
ToddChitt I am not sure if I understood your solution, can you please give more details?
And regarding tags, I use to get emails when a reply was posted to my questions, but for some reason I dont get those emails anymore.