Please help me out

[karun123]

I want the result like below in Time difference in Days with Dax.

Contactid	Stages	Timestamp	Time diff in Days
1	Active	03-12-2023
1	Qualified	03-12-2023	0
1	Options Shared	03-12-2023
1	Active	04-12-2023
1	Qualified	05-12-2023	1
1	Options Shared	05-12-2023
1	Lost Lead	08-12-2023
1	User Reactivated	31-01-2024
1	Options Shared	31-01-2024
1	Lost Lead	07-02-2024

[Anonymous · Accepted solution]

Hi @karun123 ,

Regarding your question, you can use the 'DATEDIFF' function.

DATEDIFF function (DAX) - DAX | Microsoft Learn

The Table data is shown below:

Suppose we want to calculate the date difference to today.

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