Forum Discussion

JL2007's avatar
JL2007
Frequent Visitor
3 years ago
Solved

Rolling 3 Months not Filtering

Hi, I am trying to get a rolling total of $ Values over the previous 3 months, I've been able to get this to work with the code below,  but my problem now is when trying to filter for different offic...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    try use all+values

    ALL ( '4 Year Bookings'),

    VALUES('4 Year Bookings'[Office],

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

try use all+values

ALL ( '4 Year Bookings'),

VALUES('4 Year Bookings'[Office],

JL2007's avatar
JL2007
Frequent Visitor
3 years ago

Wow! That did it! What a simple change, but made all the difference. Thanks FreemanZ,  as a newbie to this, it has been has stumping me for days!