Need help plotting a continuous 7 days of data vs average

Hi Jansco ,

I am assuming you have table visual with Date,Sales,7DaysPrior,30DaysAvg ....

Try the following measures

1.  7DaysSalesPrior =
VAR _curDate =
    SELECTEDVALUE ( Sales7Days[Date] )
RETURN
    CALCULATE (
        SUM ( Sales7Days[Sales] ),
        FILTER (
            ALL ( Sales7Days ),
            DATEDIFF ( Sales7Days[Date], _curDate, DAY ) >= 1
                && DATEDIFF ( Sales7Days[Date], _curDate, DAY ) < 8
        )
    )

2.  30DaysSalesAVG =
VAR _curDate =
    SELECTEDVALUE ( Sales7Days[Date] )
RETURN
    CALCULATE (
        AVERAGE ( Sales7Days[Sales] ),
        FILTER (
            ALL ( Sales7Days ),
            DATEDIFF ( Sales7Days[Date], _curDate, DAY ) >= 1
                && DATEDIFF ( Sales7Days[Date], _curDate, DAY ) < 31
        )
    )

3. 7DaysVs30DaysAvg =  [7DaysSalesPrior] - [30DaysSalesAVG]

Replace Sales7Days with your table name.

Cheers

CheenuSing