I've created a date table from 2019-2021, which includes a Y/Blank on working days so I can figure out the total days a ticket is open, by minusing two dates against each other. To make this accurate, I need to use this date table to not count the weekends and bank holidays in the year.
So a rough idea of what I'm trying to achieve will be:
"Complaint Received" (complaints table) minus "Final Response Sent" (complaints table), ignoring blanks in "Working Day" (date table).
Date table featuring weekend and bank holiday info^
Complaints recieved column and table (underlined) needed for DAX^
"Final Response Sent" column and table (underlined) needed for DAX ^