Rolling Average Sales Measures stopped working

[Oros]

Hello.

I have a table that has a parameter slider in increments of 7 (days).

PRODUCT	ROLLINGSUMAVE	ROLLING AVERAGE SALES PER WEEK	CURRENT INVENTORY	WEEKS TO SELL
APPLE	14	7	28	4

This table is working properly until the three columns stopped showing any data (ROLLINGSUMAVE, ROLLING AVERAGE SALES PER WEEK and WEEKS TO SELL).  This happened when a scheduled data refresh failed. Any help a greatly appreciated.  Thanks.

----------------------

I have the following measures:

Rolling Average Sales Per Week = [RollingAve]*7

-------------------------------

RollingAve =

   VAR NumDays = Parameter[Parameter Value]

   VAR RollingSum =

         CALCULATE(

SUM('SALES TABLE'[SALES]),

         DATESINPERIOD('SALES TABLE'[Postingdate], TODAY(),-Parameter[Parameter Value],DAY)

         )

     RETURN

         RollingSum/NumDays

---------------

 

RollingSumAve = VAR NumDays = Parameter[Parameter Value]

VAR RollingSum = CALCULATE( SUM('SALES TABLE'[SALES]),

DATESINPERIOD('SALES TABLE'[SALES], TODAY(),-Parameter[Parameter Value],DAY) )

RETURN RollingSum

----------------

WEEKS TO SELL =

        DIVIDE(SUM('PRODUCT TABLE'[Inventory]),[Rolling Average Sales Per Week])

[Greg_Deckler]

@Oros See if this helps: Better Rolling Average - Microsoft Power BI Community

[Oros]

Hi @Greg_Deckler,

Thank you for your quick reply.  I watch the video but unfortunately still a little bit advanced for me for the specific question that I have.  Thanks again.