Last week sales

Question

Hello all, please complete or correct my DAX expression for the following expression:
If today is Saturday calculate total sales between 5 days ago and 1 day ago from today.
&nbsp;

TotalSalesLastWeek = IF('Date'[Todayofweek] = "Sat",
CALCULATE(sum(Sales[Sales$]),
DATESINPERIOD(('Date'[Date],([Todayofweek]-1),-5,day),
.....................Meanwhile, how can I do the above expression with Switch and SelectValue?

ashish_mathur · Answer

Hi,
The general pattern is as follows:
=calculate(sum(Sales[Sales$]),datesbetween('Date'[Date],min(calendar[date])-5,min(calendar[date])-1))

koorosh · Answer

Hi Ashish, we want date between 5 days earlier today and 1 day earlier today. Why you used min expression?

ashish_mathur · Answer

Because i want to capture the value of the Date.&nbsp; I assume that you have dragged date (from the Calendar table) to the Table visual

koorosh · Answer

What is the output of the&nbsp;min(calendar[date]? Would it be today?

ashish_mathur · Answer

No.&nbsp; Assuming you have dragged dates from the Calendar Table to the Table visual, it will simply give the Date value.&nbsp; The MIN() can be replaced with MAX as well.&nbsp; You may want to share some data and show the expected result.

Forum Discussion

Last week sales

7 Replies

Related content

Last week sales issue

Previous Week Sales

Sales by Day, week and month

Rolling 52 week sales and preceding 52 week sales

Last 2 weeks sales