topic Subtracting two dates to get a TAT in DAX Commands and Tips

Subtracting two dates to get a TAT

Anonymous — Mon, 06 Feb 2023 11:24:34 GMT

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

FreemanZ — Mon, 06 Feb 2023 11:31:04 GMT

hi Anonymous

try like:

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

Anonymous — Tue, 07 Feb 2023 05:28:31 GMT

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

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.