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.
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |