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.