How to get Hours between two date and time in measure and not in column

[Anonymous]

Need help to find out how i can get the hours between two dates (date format : 17-07-2018 16:13:25) . I need to calculate this by measure so that i am not including any new column. 

Thank you

[v-diye-msft]

Hi @Anonymous 

Any updates?

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I've created a sample as below:

Measure 4 = DATEDIFF(MAX('Table (3)'[Start Date]),MAX('Table (3)'[End date]),HOUR)

[PBFlash]

You can use the datediff function in DAX.

DATEDIFF(<start_date>, <end_date>, <interval>)

https://docs.microsoft.com/en-us/dax/datediff-function-dax

[Anonymous]

Datediff works fine for new column but its not working when i am trying to use a new measure using DAX  

[v-diye-msft]

Hi @Anonymous 

DATEDIFF should work in measure as well, please share your dummy data and i'd like to draw up it for you.