Forum Discussion
Advanced date filter
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
4 Replies
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-p/963216
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/1447523I 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
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.
That's right....... show data of the last working day or worked.
