cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsandip59 Member
Member

Seconds difference between 2 dates

Hi,

I am getting below error

Cannot convert value '04-OCT-18 02:55:46.000000000 PM' of type Text to type Date.

and I am using below Dax expression:

Gateway_Time_Diff = DATEDIFF('Test'[JMS_DELIVERED_DATE_TIME], 'Test'[FIRST_TOUCH_DATE_TIME], SECOND)

 

but when I am seleting a column in query editor it says that the column data type is Date/Time:

Capture12.PNG

 

So what approach should I take for this to gate seconds between 2 date?

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Seconds difference between 2 dates

hi, @dsandip59

DATEDIFF Function is dax function and in the query editor it needs M language, 

In query editor you can do these achieve your requirement

Step2:

Add a custom column that two datetime column are directly subtracted

6.JPG

Step2:

Select the result column then click Transform->date&time column->Duration->Total seconds

Result:

8.JPG

 

And the modeling process

you could create a calculate column by DATEDIFF Function

calculate column = DATEDIFF(Table1[Datetime1],Table1[datetime2],SECOND)

9.JPG

 

Best Regards,

Lin

 

 

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 426 members 4,465 guests
Please welcome our newest community members: