Forum Discussion
Last weekday Dax formula
If you are only looking at the current year or just comparing same period last year, you can also add a field to your date table to include the day of the year. Then, add that as a filter and just manually select which day you want to end the report on. For example, if you were reporting through Friday, March 25, 2016, you would filter day of the year as being less than 86 so that it would pull in numbers through day 85 which was Friday.
I actually have this in one of my reports because of specific data requests that may change over the course of any given week. It allows me to pin down to a specific day without recreating the switch formula.
You absolutely do need a date table, however.
You can easily get around all this trouble by having a weekday/weekend indicator in a Date table instead of having to use a formula to decide what the current/last date is. This way, you can filter on the data using this field.