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 have this formula :
new column = if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 1, 0) else [EVT_TMSTMP]
but it gives me an error in new column.
My [EVT_TMSTMP] column is in Date/Time format, and looks like this:
Can anyone fix my formula so I dont get an error when a TF record is found?
Solved! Go to Solution.
Your mention of requiring 4 parameters jogged my memory and i was able to fix this. Thanks!
= if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 0, 1, 0) else [EVT_TMSTMP]
Your mention of requiring 4 parameters jogged my memory and i was able to fix this. Thanks!
= if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 0, 1, 0) else [EVT_TMSTMP]
Please, if you get an error and want help you really have to post the error message. Also, Duration takes 4 parameters
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 |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |