The ratio of total sales to the weekly average of previous 28-day sales over the past week.

[Anonymous]

I am beginner for power bı so anybody help about this topıc. pls..

My data comes from the same excel page, with sales associated with the calendar day.

X = today = June 8

A = 7-day total from June 1-7

B = May 4 - May 31, 28-day total sales

Moving Comparative Moving Average = A / (B / 4)

Is 2 clusters larger than X-35?

C> X-35 => 1

D <X-7 => 1

C + D = 2 (filter)

Dates between (X-35, X-7)

[amitchandak]

@Anonymous , refer if this can help

Check https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

In this one there formula for last 12 weeks change that to last 4 week