Filter data based on weekday and weekend

[vchauhan011]

Hello Everyone! 

My data set looks something like below table. 

Date	Value
2020-12-01	1
2020-12-02	2
2020-12-03	3
2020-12-04	4
2020-12-05	5
2020-12-06	6
2020-12-07	7
2020-12-08	8

I want my output to have today and yesterday's data. I am able to get this data using [Date] <= DateTimeAdd(DateTimeToday(),-2,"Days") formula. However, this formula is not working whenever it is Monday. whenever is it Monday, I want my output to have data from Fri, sat, Sun and Mon. any suggestion how I can get that data? 

Thank you very much in advance! 

[Qiu · Accepted solution]

@vchauhan011 
you said pervious 4 days for Monday and 2 days for others day?

[vchauhan011]

Correct! and the workflow you shared is working perfectly! Thank you very much Qiu! Appreciate your help.