I have a column that displays data from the function today-1 where it shows yesterdays data. I placed it in a filter to only show the "true" values. The issue I am having is I need to show yesterdays data but I need to exclude the weekend. Example: Today is Monday and I need to show Friday's data not Sunday's as there isn't any. Please Help.
1 Answers
The logic for this is simple. If today is a Monday, show the data for today - 3, else show the data for today -1.
=if(weekday(Table[DateColumn])=2,Today()-3,Today())
Check out the Weekday() DAX function documentation here: https://docs.microsoft.com/en-us/dax/weekday-function-dax
Related