Forum Discussion
Exclude data from last January but include data from last December
I have report based on a table of data that spans 2 and a half years and is growing. For my visuals I show a count of specific data from the last 3 months in a barchart. Generally i filer by Month and Year to limit the data, but for the my current feed I need to include data from 11/2025, 12/2025, and 01/2026. When i do this I can't figure out how to filter out data from 01/2025. And it is throwing off my data set. This seems liek it should be a simple filter to create but I am at a loss. Any help would be appreciated.
The Column I am using is a simpel Date Column, and I am selecting the Year and Month on the X-axis, then using a count of an ID column for the Y-axis. I then Filter by the Months and Years I want to show.
HI adsunderland - In the Filters pane, find the field Sample: date of result (the one currently showing Year/Month).
Change the Filter type from "Basic filtering" to Relative date.
Set it to: Is in the last | 3 | Calendar Months.
Click Apply filter.
or
anothe approach: create a measure and if you have date table for last 3 months as below and set it filter with 1
Last3Months =IF (MAX ( 'Date'[Date] ) >= EDATE ( TODAY(), -3 ),1,0)try this and let me know if any
Hope this helps.
Instead of filtering by Month and Year separately, filter using the actual Date column with a proper date range.
If this is always “last 3 months”:
-
Drag your Date column into the Filters pane
-
Change filter type to Relative date
-
Select:
-
In the last → 3 → Months
-
This automatically returns:
-
11/2025
-
12/2025
-
01/2026
And it will dynamically move forward every month.
-
6 Replies
HI adsunderland - In the Filters pane, find the field Sample: date of result (the one currently showing Year/Month).
Change the Filter type from "Basic filtering" to Relative date.
Set it to: Is in the last | 3 | Calendar Months.
Click Apply filter.
or
anothe approach: create a measure and if you have date table for last 3 months as below and set it filter with 1
Last3Months =IF (MAX ( 'Date'[Date] ) >= EDATE ( TODAY(), -3 ),1,0)try this and let me know if any
Hope this helps.
Instead of filtering by Month and Year separately, filter using the actual Date column with a proper date range.
If this is always “last 3 months”:
-
Drag your Date column into the Filters pane
-
Change filter type to Relative date
-
Select:
-
In the last → 3 → Months
-
This automatically returns:
-
11/2025
-
12/2025
-
01/2026
And it will dynamically move forward every month.
-
Thanks cengizhanarslan and rajendraongole1 your solutions were exactly what I was looking for. And will save me from having to update some of the visual styles every month as we add new data!
Hi,
You should first of all be creating a Calendar table. Thereafter you can use the datesbetween and calculate functions to solve your problem. To get more specific help, share some data to work with. Share data in a format that can be pasted in an MS Excel file.
Hi adsunderland,
I would also take a moment to thank cengizhanarslan , rajendraongole1 for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Community Support Team.Hi adsunderland,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.
