Relative date filtering doesnt show te right result

[christianfcbmx]

Hello, I want to use "Relative date filtering feature" and I cant make it work right: I want to show items when the value is in the last 4 months only but still show part of the fifth month (OCTOBER) WHY?...anybody could help me out? Thnaks in advance...

[Anonymous]

Just to make sure i understand what you are asking:

You have the relative date filter on and you have selected 'Past 4 months'.  In your example is currently the date range 27-Oct-17 until 26-Feb-18.

You have asked that you want it to show the data from the Part month October (dates 27th until 31st).  Looking at the graph that appears to be the case.

Can you please clarify how the graph differs from your expectation?

[christianfcbmx]

Hi Ross! thank you for the quick reply... that is exactly my problem,,,Dont know why it takes part of october automatically...as you said it takes from 27-Oct-17 until 26-Feb-18 and I havnet chose that rule....and no idea why?

[Anonymous]

As you can see in the screenshot, if you do a date math of Today's date minus 4 months, you get a date part way into October.

Instead you need to select "calendar months" in the dropdown, under where you typed 4.  You will notice this change to be from October 1st until January 31st.

[christianfcbmx]

But I dont have checked where it said include today.... well I tried that one but I lose what I have in feb... I expect to have the 1st October until feb 15th...is that posible?  

[Anonymous · Accepted solution]

It is, we just need to get a little clever 😉

First, find the table where your [Date] column is stored.  Create a new calculated column with the following DAX statement:

MonthGroup = DATE(
        YEAR([DATE]),
        MONTH([DATE]),
        1
)

Use this new field for your relative date filtering, using the method you had in your original post.  Now you will have only from the start of November until the current date.

[christianfcbmx]

Thank you Ross...I learn!!!