Calculated column for a value for next 6 days

[Anonymous]

I am facing an issue with calculated column.

This is sample data and here I want to achieve if isStoreClosed is Closed Status then I want to divide the Daily_Split Value by 6 and add this average value to the next 6 Retail Dates Daily_Split Value.

I have created the Daily_Split2 Column and written the folloing dax to achieve the result

Daily_split 2 =

VAR Closed =

    CALCULATE (

        SUM ( 'Daily Table'[Daily_Split] ) / 6,

        FILTER (

            'Daily Table',

            'Daily Table'[IsStoreClosed] = "Closed"

                && 'Daily Table'[Store_Code] = EARLIER ( 'Daily Table'[Store_Code] )

                && 'Daily Table'[Retail Date] = EARLIER ( 'Daily Table'[Retail Date])

                && 'Daily Table'[Iteration] = EARLIER('Daily Table'[Iteration])

                && 'Daily Table'[Category]= EARLIER('Daily Table'[Category])))

   return

    IF (

        'Daily Table'[IsStoreClosed] = "Open",

        CALCULATE (

            SUM('Daily Table'[Daily_Split])+ Closed,

            FILTER (

                'Daily Table',

                'Daily Table'[Store_Code] = EARLIER('Daily Table'[Store_Code])

                && 'Daily Table'[Retail Date] >= EARLIER('Daily Table'[Retail Date])

                && 'Daily Table'[Retail Date] <= EARLIER('Daily Table'[Retail Date]) + 6

                && 'Daily Table'[Iteration] = EARLIER('Daily Table'[Iteration])

                && 'Daily Table'[Category]=EARLIER('Daily Table'[Category])

            )

        ))

But this Code not giving me the desired result. I am not able to add the average value to the next 6 days.
How do I fix this any help please.

[Anonymous]

@lbendlin I have got the DAX part and the problem is solved now. Thanks for your message.

[lbendlin]

Next six days from what?  The row context?  The "current"  date (whatever that is)?  Is your data source in import mode?