cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YoussefN Frequent Visitor
Frequent 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.

 

 

ScreenHunter 285.jpgCall date

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculation in hours between date and time

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 )
2 REPLIES 2
Super User
Super User

Re: Calculation in hours between date and time

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 )
YoussefN Frequent Visitor
Frequent Visitor

Re: Calculation in hours between date and time

wow @Zubair_Muhammad

 

Thanx for your quick response it worked!

 

Youssef

Helpful resources

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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 312 members 3,252 guests
Please welcome our newest community members: