Forum Discussion
Relative date filtering doesnt show te right result
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...
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.
6 Replies
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?
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?
