Advanced date filter

[Syndicate_Admin]

Dear

I have built a model that I have as a date a day prior to today, but I need to be able to establish that the previous day is a working day or a working day. Currently I have been working in this way

I need to be able to filtar that if previous day is Sunday, show me the last working day

[Syndicate_Admin]

I give more details,

I have built a report that gives me sales data, which is filtered in such a way (relative date filter), that for example on Friday 17/03 when I open the panel, it shows me the data of the previous day (Thursday 16/03), up to that point I have no problems. The problem is presented to me when I want to review the information on Monday (Only movements are generated from Monday to Friday) and I want to review data from the last day worked

As a consideration, all the dates I bring from my calendar table

[lbendlin]

flip your question around.  Show transactional data from the maximum date that is not "today".  That means if the previous friday was a holiday then on monday you would see thursday data etc.  

[Syndicate_Admin]

That's right....... show data of the last working day or worked.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523