Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
I have done that and get an error "Cannot convert value '' of type Text to type Number."
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
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
What field type does my new column need to be as I get the following response as the new column is set to text?
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
I have put this in and get the following:-
this is what I have put in the column
Try this then:
Comm_Duration_Decimal =
VALUE (
FORMAT ( SELECTEDVALUE ( Procurement_Data_2[Comm_Duration_mins] ), "0.00" )
)
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
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
20 | |
15 |