Help with DAX - Week to date last selected Week

[EsmeeSnijders]

Hello,

I am creating a formula in DAX with which we want to calculate the sales week to date. 

We have a report with a date filter and an amount to be shown per weekday, only from the last filtered week. 

The date filter can be selecterd for a longer period than one week, and we are looking for a formula that returns the amount of sales for the last selected week, shown per weekday. 

Example:

Date	Weekday	SalesAmount
15-05-2023	Monday	10
16-05-2023	Tuesday	25
17-05-2023	Wednesday	20
18-05-2023	Thursday	25
19-05-2023	Friday	10
20-05-2023	Saturday	25
21-05-2023	Sunday	30
22-05-2023	Monday	10
23-05-2023	Tuesday	30
24-05-2023	Wednesday	25
25-05-2023	Thursday	50
26-05-2023	Friday	10
27-05-2023	Saturday	35
28-05-2023	Sunday	10

In the report i have filtered the intire period. From 15-05-2023 till 25-05-2023. What I want is the sales amount, shown per weekday only of the last selected week. 

So what I expect to see in the report is: 

Monday 22-05-2023	Tuesday 23-05-2023	Wednesday 24-05-2023	Thursday 25-05-2023
10	30	25	50

Can anybody please help me? 

Thank you so much!

[Mahesh0016 · Accepted solution]

Hello @EsmeeSnijders  i hope this helps you!THANK YOU!!

First your create WEEKNUM Column :

WeekNum = WEEKNUM('Table'[Date],2)

Then create measure  :

MXweek = MAX('Table'[WeekNum])

after that apply Matrix visual level filter 

@EsmeeSnijders THANK YOU!!

[EsmeeSnijders]

It works!! Thank you so much!