Forum Discussion

espinozan's avatar
espinozan
Icon for Helper I rankHelper I
9 years ago
Solved

Creating a 12 month rolling trend report using Calendar

Hello all,   I've been trying to research the best way to create a 12 month rolling trend report in Power BI. Somehow, I can't seem to find what I'm looking for. So far, I've notived most use calcu...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago
    Aah, then try something like (untested code) :

    =IF([Date]<Today()-365;False();IF([Date]>Today();False();True()))

    Filter column by "True".
Salvador's avatar
Salvador
Icon for Responsive Resident rankResponsive Resident
9 years ago

Hi,

 

Havent tried it, but... perhaps max?

espinozan's avatar
espinozan
Icon for Helper I rankHelper I
9 years ago

Yes!

 

MAX() worked! 

 

Thank you both Anonymous and Salvador for helping me. I appreciate it so much. Below is my final syntax. 

 

Then filter visuals by "True."

12M Rolling Trend = 

       IF([Date]< MAX([Date])-365,FALSE(), 

             IF([Date]> MAX([Date]), FALSE(), 

                   TRUE() ) )