Hi, I am trying to calculate the difference between two dates using Datediff but only count working day. The workday Y/N is in the Date Table, the other two dates is between today and order date. When I use Datediff(todayutc,orderdate, days), the formula works fine. However I only want to count …

@ElizabethTachjian , I thought we addressed this same question in the thread below last summer: [image] DateDiff to only calculate number of work days DAX Calculations Hi Brian, Datesbetween for my situation which has no dates till job is complete, will not work because o…

Datediff workday pnly

DAX DAX Calculations

BrianJ February 4, 2020, 10:30pm 2

@ElizabethTachjian,

I thought we addressed this same question in the thread below last summer:

Here are some more videos and forum threads that also address this question in detail:

I hope this is helpful.

Brian