Enhanced Feature Request: Relative Date Filter – Include Current Partial Month

[RajPBI]

Description
In the current Power BI Relative Date filter, when selecting the option:

• Filter Type: Relative date
• Operator: "is in the last"
• Value: n
• Unit: calendar months

…the filter returns data from the previous n full calendar months, excluding the current month, even when the current month has partial data available.

Problem
This behavior limits reporting scenarios where users need to analyze data for the previous n calendar months up to today, including the current partial month.
To meet this requirement today, we must rely on custom DAX calculations to dynamically include the current month.

Requested Enhancement
Please extend the Relative Date filter to include an additional option that allows users to:

Show data for the previous n calendar months through today (including the current partial month).

This could be implemented as a new toggle or an additional operator such as:

• “is in the last n calendar months (including current month)”,
  or
• A checkbox: “Include current partial period”.

Rationale
This enhancement would:

• Reduce the need for custom DAX workarounds.
• Improve usability for business users who rely on built‑in filters.
• Align date filtering behavior with common reporting needs (e.g., rolling n‑month analysis).
• Ensure consistency across filter types, visuals, and dashboards.