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. 

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

matsahiro 

 

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

 

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

Definitely gave it a go. The IF statement ended up not working for a specific visual I had, but I simply threw in the same logic in a CALCULATE statement. 

Rolling 12 Month Count =
VAR Start_Date = EOMONTH(TODAY(), -14)+1
VAR End_Date = TODAY()

RETURN
CALCULATE(COUNT(Table[Column]), Table[Column] >= Start_Date && Table[Date] <= End_Date)
 
Thank you very much for the help!