Time field difference

[spandy34]

I have the table below which includes two columns which are time fields.I want to add a column called Lost Time that subtracts the Actual_Duration_mins from the Comm_Duration_mins.  What will the DAX be for this please as I didnt know if it was different if I was using time fields.  

I am new to DAX so please bare with me

Thank you

@goncalogeraldes @tamerj1 

[goncalogeraldes · Accepted solution]

Hello there @spandy34 ! I figure that you are expecting a measure so here goes. 

Hope this works for you:

Lost Time =
DATEDIFF (
    SELECTEDVALUE ( 'Table'[Actual_Duration_mins] ),
    SELECTEDVALUE ( 'Table'[Comm_Duration_mins] ),
    MINUTE
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[spandy34]

Thank you very much

So I have the column below which is a which the format Time.  I want to create another column that is a decimal of that so for example if the column says 0.30 I want the new column to display 0.5 as a decimal of an hour.

Can you help with the DAX for that please.

THank you @goncalogeraldes 

[goncalogeraldes]

You can use the FORMAT() function:

New column =
FORMAT ( Table[Comm_Duration_mins], "General Number" )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[spandy34]

What field type does my new column need to be as I get the following response as the new column is set to text?

[goncalogeraldes]

Just go:

New column =
VALUE( FORMAT ( Table[Comm_Duration_mins], "General Number" ) )

 Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[spandy34]

I have put this in and get the following:-

this is what I have put in the column

Comm_Duration_Decimal = VALUE(FORMAT ( Procurement_Data_2[Comm_Duration_mins], "General Number" ) )

[goncalogeraldes]

Try this then:

Comm_Duration_Decimal =
VALUE (
    FORMAT ( SELECTEDVALUE ( Procurement_Data_2[Comm_Duration_mins] ), "0.00" )
)

[spandy34]

I have done that and get an error "Cannot convert value '' of type Text to type Number."