DATEDIFF, separate tables in dax

[Anonymous]

Hi All,

I have 2 tables, date and order. In order table 2 date columns, date received and date replied. I want to calculate the response time. If the date received falls on holiday then want to subtract the date replied with the next working day of date received. I have the next working day date column in the date table. As networking day date and date replied in different table I am not able to subtract it. 

if(order[date received] =date[date]&&isworking day = false),(order[date replied ]-date[nextworkingdayedate]),(order[date replied]-order[date received])

Can you please help me to achieve this.

Thanks

MB

[nandukrishnavs · Accepted solution]

@Anonymous 

Create a calculated column, Use LOOKUPVALUE() to get the next working day.

Then create another calculated column to find the difference using DATEDIFF()

DATEDIFF([Date],[Date2],DAY)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂