How to show the last 13 months only using date hierarchy

[KK22]

Hi,

I need to show the last 13 months on a monthly report as Feb 2021 to Feb 2022,  March 2021 to March 2022 and so on. I would like to keep using date hierarchy because the chart looks neat this way.   However, If I select Year 2021 it's started from January, not March.  If I unselect January it is gone from both years. Is there any additional filtering option?

Thank you.

[davehus · Accepted solution]

Hi @KK22 , Would using a relative date filter using your date key work. Set it to is in the last 13 months/calendar months?

[CNENFRNL]

Fairly easy by means of time intelligence func as they invoke ALL() implicitly for evaluation.

[KK22]

Thank you CNENFRNL  for the responce and pointing toward the functions; however it could have been realy useful if the finction  name was mentioned. 

[davehus · Accepted solution]

Hi @KK22 , Would using a relative date filter using your date key work. Set it to is in the last 13 months/calendar months?

[KK22 · Accepted solution]

Thank you davenhus, I followed your advice and it worked.