Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to do a time subraction as a calculated column.
For example, the highlighted row should have hours = 8.5 (6:30 pm - 10:00 am)
Can this be done as a column or do I have to use a measure?
Solved! Go to Solution.
Hi,
This calculated column formula works
=(Table1[End_Date_Repeat]-Table1[Event_Date_Repeat])*24
Hi,
This calculated column formula works
=(Table1[End_Date_Repeat]-Table1[Event_Date_Repeat])*24
This worked...thanks!!
You are welcome.
Hi @i820017 ,
Here a solution with a measure:
DAX:
DurationMeasure = SUMX (Table, DATEDIFF ( Table[Event_Date_Repeat], Table[End_Date_Repeat], MINUTE ) / 60 )
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
This solution worked as well, but I wanted the solution as a calculated column.
Hi @i820017 ,
Here a solution for a calculated column:
DAX:
DurationCol = DATEDIFF ( Table[Event_Date_Repeat], Table[End_Date_Repeat], MINUTE ) / 60
Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |