I have three tables, Public Holidays which contain (Date, Holiday Binary (1 for each date that is a holiday date)), CalDates that contains (Date, WorkingDay_Mark (1 for working day, 0 for non working day)) and Deployment_Mailbox that contains (Date Received (Date the email was received))
I need to create a formula to show the age of an email from Deployment_Mailbox (Date Received) minus any weekend days and holiday days
Not sure if this would need to be Power Query M or DAX
I have got this far with it, this gives me the age minus weekends, but I can't work out how to also minus any holiday dates.
I created a SatSuns measure:
I need to create a formula to show the age of an email from Deployment_Mailbox (Date Received) minus any weekend days and holiday days
Not sure if this would need to be Power Query M or DAX
I have got this far with it, this gives me the age minus weekends, but I can't work out how to also minus any holiday dates.
I created a SatSuns measure:
Power Query:
SatSuns =
Countrows (Filter (
CALENDAR(Min(Deployment_Mailbox[Date Received]),TODAY() ),WEEKDAY([Date],2) > 5)
)
Power Query:
CAL_AGE =
DATEDIFF(
MIN(Deployment_Mailbox[Date Received]),
TODAY(),
DAY
) - [SatSuns]