Forum Discussion

matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago
Solved

Last 12 Complete Month Rolling Filter

Hello, I have a visual where I would like to display only data for the last 12 complete months. For example, if today is 5/12/2021, the data I would like to be displayed would be running from 4/1/202...
  • Fowmy's avatar
    Fowmy
    5 years ago

    matsahiro 

     

    Hope you tried my solution to your problem, let me know if it works. 

     

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

This is the DAX forum so it's no surprise you've got a DAX answer.  I'd just point out this functionality is available in the UI.  Use a relative date slicer or filter with calendar month.

 

  • matsahiro's avatar
    matsahiro
    Icon for Helper II rankHelper II
    5 years ago

    Hi Paul. You are correct that it is available in the UI. But if you notice, this does not meet my requirements as the data that is being filtered in does not start at the beginning and end of each month.