Forum Discussion

Advocate I

1 year ago

Solved

Rolling values for 3 months

Hi Guys, Could you help me configure this? I'm trying to display the rolling 3-month period like below. I'm trying to incorporate the code into a measure within my actual dataset, bu...

rohit1991
1 year ago
Hi wyanjaspew

Could you please check this:
In Model view, create a relationship from Date Table[Date] (1) to Fact Sales[Date] (*)

MohamedFowzan1

Super User

1 year ago

Hi wyanjaspew

Could you check if this works:

Rolling 3 Month Total =
CALCULATE(
    SUM(FactTable[ValueColumn]),
    DATESINPERIOD(
        'DateTable'[Date],
        MAX('DateTable'[Date]),  
        -3,
        MONTH
    )
)

wyanjaspew
Advocate I
1 year ago
When I apply this code, it only display the same numbers (sum) of my serviceid's