cancel
Showing results for
Did you mean:
Highlighted
Super User IV

## Re: Calculate hours between two date/time column

Hi,

Mine is a calculated column formula - not a measure.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted

## Re: Calculate hours between two date/time column

i have also created calculated column

Highlighted

## Re: Calculate hours between two date/time column

Datediff = DATEDIFF(Table[start date time final],Table[End date time final],Hours)
Highlighted
Super User IV

## Re: Calculate hours between two date/time column

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Super User II

## Re: Calculate hours between two date/time column

@sathyaramesh are your columns really dates and times? They must be for this to work. They cannot be text that looks like it. That might be why you are getting zero. Check out this CONVERT() function in DAX and see if that helps.

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting
Highlighted

## Re: Calculate hours between two date/time column

Hi @edhans

The column is of date/time column.

Highlighted
Super User IV

## Re: Calculate hours between two date/time column

datediff =datediff(startate,enddate, HOUR)

Not hours, make sure that is correct.

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Super User IV

## Re: Calculate hours between two date/time column

Yep, works

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted

## Re: Calculate hours between two date/time column

Sorry for my mistake. I made some mistake in calculated column.(I used both date as (start date time) for finding difference).

i think its working fine. Thank you so much for all your replay

Highlighted
Super User IV

## Re: Calculate hours between two date/time column

No, my apologies @sathyaramesh, that one is all on me, I actually originally posted ,HOURS and moved on and it bugged me whether the syntax was actually HOUR or HOURS but I didn't check, I figured DAX intellitext would save you if I got it wrong. My bad.

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors