The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
51 | |
51 | |
46 |