Show results for last X months of my data

[Michael_Gold]

Hello, I have a dataset that shows data ranging from2014 to 2018

There is also a daily calendar table

I created a graph and set a date hierarchy of Year&Month (using the drilldown)

Now I would like to present only the last X months from the dataset (without manually entering the range in the filters pane)

However when I try to show the last X months/calendar months the graph does not show any data as it calculates last months from Today ..

 Would appreciate some help

[Anonymous]

Hey have you created any measures to specialize your need to filter last month data? 

[Michael_Gold]

Hi, I did not quite understand the question. I did not create any measure.

I want to present the data only for the last X months in the database

[Anonymous]

Hi @Michael_Gold ,

Please do not use fields in Date hierarchy. Please use YEAR() and MONTH() to create calculated columns in the calendar table and use them.

The Date hierarchy automatically creates all the dates for the full calendar year, possibly including dates that are not in the model, which is the reason for the problem.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data