How to select last x months of data in a dataset

[larsvillaume]

I have a dataset with 18 months of data. For a visual I want to use only the last 6 months of data. Do I create a new measure and used CALCULATETABLE with a FILTER and then add that field to the filter for the visual?

Something like this except it should be Last x months...mayby?

Last6Months = CALCULATETABLE(VALUES(IncidentsLast18Months[Created Date]), FILTER(IncidentsLast18Months,IncidentsLast18Months[Created Date] >= DATE(2019,5,1) && IncidentsLast18Months[Created Date] <= DATE (2019,11,30)))

The dataset contains these fields.

br

Lars

[V-lianl-msft · Accepted solution]

Hi @larsvillaume ,

You can drag [Created Date] to Filters and select Filter type as "Relative date filtering", then select the data you want to display last X months.

Best Regards,

Liang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.