Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
YoussefN
Regular Visitor

Calculation in hours between date and time

Hi,

 

I have a table with logging moments for service calls. I use two measures to find the first start date

Date Time Created = CALCULATE(MIN(PBI_SER_Doc_ref_point[Date_Time_Registrated]);FILTER(PBI_SER_Doc_ref_point; PBI_SER_Doc_ref_point[Reference_Point]="8"))

and the date when the call is closed

 

Date Time Function Recovered = CALCULATE(MAX(PBI_SER_Doc_ref_point[Date_Time_Registrated]);FILTER(PBI_SER_Doc_ref_point; PBI_SER_Doc_ref_point[Reference_Point]="10"))

Now I want the caluclate the difference between those measures. But when I use a measure to calculate the difference I get an date as awnser. I want the total difference in hours. I also added an example of my table which I extract.

 

 

Call dateCall date

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

Hi @YoussefN

 

Try the DateDiff function in DAX

 

https://msdn.microsoft.com/en-us/library/dn802538.aspx?f=255&MSPPError=-2147217396

 

Try this MEASURE

 

MEASURE =
DATEDIFF ( [Date Time Created], [Date Time Function Recovered], HOUR )

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

Hi @YoussefN

 

Try the DateDiff function in DAX

 

https://msdn.microsoft.com/en-us/library/dn802538.aspx?f=255&MSPPError=-2147217396

 

Try this MEASURE

 

MEASURE =
DATEDIFF ( [Date Time Created], [Date Time Function Recovered], HOUR )

Regards
Zubair

Please try my custom visuals

wow @Zubair_Muhammad

 

Thanx for your quick response it worked!

 

Youssef

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.