This article shows a technique to handle filter-preserving columns in DAX, so that the selection of weekdays is respected when using time intelligence functions.
Article and download: https://sql.bi/871636?aff=yt
How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt