E-mail processing time to exclude weekends

Question

Hi,&nbsp;&nbsp;I need to exclude weekends from the tab "processing time" (Attributes.LastModifiedTime - DateTimeReceived -&gt; weekends out of this equation) in below picture. I understand that there are several threads about subjects close to this but either I can't get them to work or they dont apply to my situation. Anyone with an easy-to-understand solution? Thank you for your help in advance!&nbsp;&nbsp;

amitchandak · Answer

Refer:https://community.powerbi.com/t5/Desktop/Time-difference-between-two-date-times-excluding-weekends-and/m-p/563564https://community.powerbi.com/t5/Power-Query/Date-Time-difference-excluding-weekends-and-factoring-working/m-p/707793&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date RangesConnect on Linkedin

Forum Discussion

E-mail processing time to exclude weekends

1 Reply

Related content

DATEDIFF excluding weekends

Previous Day Balance - Excluding Weekends

Exclude weekends from Date Measure

calculations excluding weekends

Slicer to show date include weekend or exclude weekend