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.
Hi,
I need to Modify Hours Column in My table.
Currently i have two Columns 1. Days 2. Hours as shown in the pic below.
Hours value at present is Total Hours but my requirement is to get Hours Value if and only if Days value is zero.
ex: if day value is 1, Hours value should be zero.
if day value is zero, then only hours value should populate by excluding the days.
thanks
santosh
Solved! Go to Solution.
Hi @SantoshKumar,
Here we can use MOD function to work on it.
Hours = IF(Table1[Days]=1,0,MOD(DATEDIFF(Table1[StartTime],Table1[EndTime],HOUR),24))
Regards,
Frank
Hi @SantoshKumar,
Here we can use MOD function to work on it.
Hours = IF(Table1[Days]=1,0,MOD(DATEDIFF(Table1[StartTime],Table1[EndTime],HOUR),24))
Regards,
Frank
Try:
Hours = IF([Days]>0,0,DATEDIFF...)
So, just plug in your formula for the FALSE condition.
Thanks @Greg_Deckler
i was able to get the details in sql when i providde my query as: DateDiff(Hour,StartTrgTime,endTrgTime)%24
when it comes to PB_query - i have below option