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.
Morning all - I am running into an issue with a custom column. I want to add a day to a date field if my time field = 12:00:00 AM but it is not working. Not sure where I am going wrong here, but hoping it is a simple issue
I want to add a day to [Shift date] if [Shift end time.1] = 12:00:00 AM
What I am using now that is not working:
if [Shift end time.1] = #duration(0,24,0,0)
then
Date.AddDays([Shift date],1) else [Shift date]
Solved! Go to Solution.
if Number.From([Shift end time.1]) = 0
then
Date.AddDays([Shift date],1) else [Shift date]
if Number.From([Shift end time.1]) = 0
then
Date.AddDays([Shift date],1) else [Shift date]
It worked, thank you so much! And wow, I was way off, but thanks to people like you, learning more every day!
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 |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |