Updated: Jun 8, 2020
If you are new to Power BI then DAX and Queries can get a little confusing. Well, it did for me. If it didn't bother you then I guess you are a genius! :)
So, the task assigned to me was to get all data ranging between last week Tuesday to next week Monday. Sounds crazy right?
Well, your solution is right here.
Use a simple function - WeekDay() to get next week (Monday) and last week (Tuesday) date in Power BI!
You can use this in several ways to get data from date ranges. Don't forget the function returns the day of the week and the week starts from Sunday. So, Sunday = 1, Monday = 2, Tuesday = 3 and so on.
Let me know by leaving a comment in the video about how it has helped you and if you have a better solution!