Power BI

New

Need a relative dates filter allowing "calendar months" including current MTD

Vote (27)

Quinn Clark on 27 Dec 2017 03:00:13

Current page-level filters allow us to look at relative months and years as simple "months" or "calendar months". "Calendar months" always excludes the current MTD, but that's exactly the range that I'm often looking for: Select data for whole prior months and MTD for the current month.

Comments (6)

Comments (6)

54a5870b 35c7-ea11-a812-000d3a9b112e on 16 Jul 2020 07:24:36

RE: Need a relative dates filter allowing "calendar months" including current MTD

I agree, this feature is really needed!

ad92ec52 59f8-4597-98f1-67f2c2e4f9a2 on 06 Jul 2020 00:02:05

RE: Need a relative dates filter allowing "calendar months" including current MTD

As far as I know, there's still no way of doing it but using a filter on a calculated column (N days/months/years from now). This is an ugly solution to the final user.

A checkbox "include current" when we select "Next/Last" and "XXXXX (Calendar)" would be a much more elegant solution, imho.

Looking forward to see this implemented.

Cheers

45fbd547 2cb9-492c-9e88-a3bf7f817aba on 05 Jul 2020 23:51:55

RE: Need a relative dates filter allowing "calendar months" including current MTD

Yes! please do this! Just like the "include today" check box

43b5d688 47e6-402e-ada3-4db782e30a06 on 05 Jul 2020 23:32:16

RE: Need a relative dates filter allowing "calendar months" including current MTD

I am looking for exactly the same. Running 12 months rolling plus MTD is a completely needed filter. Now it takes 365 days excluding always some data from the latest dates. imagine today taking from 16/10/2018 until 16/10/2017. I am excluding 15 days from last years october. Would need a solution for this.

18aa1c62 e6f8-4e91-8202-fe37d7822181 on 05 Jul 2020 23:18:26

RE: Need a relative dates filter allowing "calendar months" including current MTD

This would make life so much easier and much tidier reports! When looking at how performance is trending the user wants to see the historic results AND current position. At the moment I have to use non dynamic filters which the user has to manually amend as each month passes. Its frustrating as the relative date filter would be perfect if it could just have the "include current month" tick box like it does for 'Days'. Please can this be added!

eb4d6a10 946b-4a92-b74f-4dbc9e332a96 on 05 Jul 2020 23:17:42

RE: Need a relative dates filter allowing "calendar months" including current MTD

Yes, that would be a really good new feature! Need that too :)