Subtracting two dates to get a TAT

[Anonymous]

Hi there,

I have what I think should be a very simple formula but I can not seem to work it out!

I have one date that I want to take away from another date and I want the output to be a number.........

example - Engineering sign off date - Supply chain sign off date = Turn around time 

1/1/23- 5/1/23=4

[Anonymous · Accepted solution]

Hi @Anonymous 

You can use function DATEDIFF() function.

e.g Create a calculated column.

Column = DATEDIFF([Engineering sign off date],[ Supply chain sign off date],DAY)

Output

You can refer to the following link to know more about the function

DATEDIFF function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi @Anonymous 

try like:

Column = INT([Date1] - [Date2])