Total Sales Previous 5 dates of 7 days interval based on selected date

[BItoken]

Hi,

I have a requirement where when i select a date, i need to get the total sales of the Selected date and 7 days apart upto 5 series including the selected date.

For Example:  If selected date is 20-Aug (Will be a filter where user can select any date)

This is a snapshot data of the sales taken everyday so the requirement is to check the trend in total sales based on selected dates as to what were the total sales on the particular day where a snapshot of the whole data is being taken every day

Selected Date		Output Dates
20-Aug		20-Aug
		13-Aug
		6-Aug
		30-Jul
		23-Jul

Any help is much appreciated

[V-lianl-msft]

Hi @BItoken ,

Based on my understanding, I'm afraid this can't be achieved. If you want to display these dates as slicers, you need to create corresponding calculated columns. However, the calculated column is static and cannot be changed dynamically according to the slicers.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@BItoken , assume you have a date table and you have selected a date , Try a measure like

measure =
var _max = maxx(allselected(Date), Date[Date])
return
calculate(countrows(date), filter(all(Date), date[Date] >= _max -35 && mod(datediff(date[Date], _max,day),7) =0 ))

plot with Date of date table.

[BItoken]

@amitchandak  i have to calculate the sum of the sales for these dates actually.

I tried using ur function but it does not generate any data

last 7 day series 5 =

var _max = maxx(allselected(Date_table), Date_table[fulldate])

return

calculate(SUM(Sales[Total Sales USD]), filter(all(Date_table), Date_table[fulldate] >= _max -35 && mod(datediff(Date_table[fulldate], _max,day),7) =0 ))