Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello! I am wanting to create a slicer/filter of a date. I want to create an option of
1) Past 3 months
2) Past 6 months
3) Past 12 months
4) All Data
How do I go about doing this? I wanted to do a relative date filter, but I do not want to show days and weeks.
Thanks in advance!
Hi @nataliesmiy1357 -Please create a calculated column in your date table as below:
Hope this helps
Proud to be a Super User! | |
This is a great start! But I need the Past6Months to include the Past3Months as well - how is that possible?
User | Count |
---|---|
84 | |
78 | |
70 | |
47 | |
42 |
User | Count |
---|---|
106 | |
50 | |
49 | |
40 | |
40 |