DAX to Filter Past 2 Calendar Weeks, Current Week, and Future Weeks

[markefrody]

Hi,

I am using storage mode: DirectQuery and would like to have a DAX wherein it will filter the past 2 calendar weeks, current week, and future weeks. For example:

Today is June 22, 2023
The past 2 calendar week days will be: Jun 4, 2023 to June 17, 2023
Current week days will be: June 18, 2023 to June 24, 2023
Future week days will be: June 25, 2023 onwards.

Appreciate your kind assistance.

Best regards,
Mark V.

[Ahmedx · Accepted solution]

pls try this

https://1drv.ms/u/s!AiUZ0Ws7G26RiQ2IrSgI0tmP772e?e=y3fkwU

[markefrody]

Thank you very much @Ahmedx! Works great! Just modified the variable name but overall it works.