Forum Discussion

purpletiger's avatar
purpletiger
Frequent Visitor
7 years ago
Solved

Rolling 12 Month Sum with filter

Hello! I am working on a Rolling 12 month performance which includes actuals up to today (-15) and the budget going forward. Using datesinbetween works great until I only want to display one year (2...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi purpletiger ,

     

    It looks like parentheses causes the error. Please try this one.

    RollingBase =
CALCULATE (
    [Amt Base],
    FILTER (
        ALL ( DATET ),
        DATET[Date] <= MAX ( DATET[Date] )
            && DATET[Date]
                >= ( TODAY () - 15 )
    )
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi purpletiger ,

 

It looks like parentheses causes the error. Please try this one.

RollingBase =
CALCULATE (
    [Amt Base],
    FILTER (
        ALL ( DATET ),
        DATET[Date] <= MAX ( DATET[Date] )
            && DATET[Date]
                >= ( TODAY () - 15 )
    )
)

Best regards,

Yuliana Gu

purpletiger's avatar
purpletiger
Frequent Visitor
7 years ago

THANK YOU! So simple, I was thrown off by the error message.