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.
Is it possible to create a new column with a calculation that takes calldate - info2 (call time in seconds)? calldate is the closing time and info2 is the calling time. I need to identify the start of the call.
Solved! Go to Solution.
If your call end time is a DateTime column and the duration in seconds is a number column, you can use this formula in a custom column in M/query. Just add a custom column and use this formula.
=[CallEnd]-#duration(0,0,0,[info2])
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, @mahoneypat ,
Tks!! The formula didn't work. I tried to convert the info2 column to an number, but it still didn't work. See the pictures:
If your call end time is a DateTime column and the duration in seconds is a number column, you can use this formula in a custom column in M/query. Just add a custom column and use this formula.
=[CallEnd]-#duration(0,0,0,[info2])
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yesssss Its work!!!!1 Thanks!!!!!!!!!
Glad you got it working. What was causing the error?
If that approach worked, please mark it as solution. Kudos are appreciated too.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, @mahoneypat ,
Tks!! The formula didn't work. I tried to convert the info2 column to an number, but it still didn't work. See the pictures:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
64 | |
63 | |
56 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |