Count Weekend Sales

[joshua1990]

Hello everyone!

I have a transactional table that shows me the sales for every article on a daily level:

Date	Article	Key	Sale
01.01.2021	A	A1	50
02.01.2021 (Sat)	A	B	50
03.01.2021 (Sun)	A	B	70
04.01.2021	A	A1	80

As you can see there were sales on the weekend (03. & 04. ). Every weekend sales has the key 'B'.

What I now want to determine is if there was a sale on each weekend in the previous 3 weekends  - regardless if it was a Saturday and/or Sunday.

How would you do that with a DAX measure?

[Anonymous]

Hello @joshua1990 ,
You can try this.
Total Sales = 
CALCULATE(
                     SUM( 'TABLE'[SALE] ),
                     KEY = "B"
)
You can put into visual and put a date filter on the visual level of relative date is in the last 21 days.