Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I create a filter that shows only the last 3 months of a date field? I have a column of data called Created Date and in a specific dashboard/component I want to show data for the last three months. Instead of manually selecting the last three months every month was hoping to create a formula of some sort so that the dashboard components update each month on it's own. Is this possible?
Thanks,
Arun
Hi @aviswana27,
Create a calculated to check if the date is under the last 3 month or not, and then drag this new created calculated into a slicer visual to filter the data.
Last3Month = IF(AND(YEAR(TODAY())=YEAR('Date'[CalendarDate]),(MONTH(TODAY())-MONTH('Date'[CalendarDate]))<3),"Last 3 month","Other")
Regards,
Charlie Liao
MonthsAgo=DATEDIFF(TODAY(),[Created Date],MONTH)
Create as a new column and then use that to filter < 2.
If you need year factored in, you might have to do some slighly more complicated calculations.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |