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.
From the below date column a new calculated column 'shift_id, is needed
if the time is 8am to 9am time shift_id is 1
if the time is 7am to 8am shift_id is 5
if the time is 4pm to5pm shift_id is 10
within the same date, date would be filtered based on power bi slicer though.
etc...
thnaks
Solved! Go to Solution.
hi @rafiql09
try like:
shift_id =
VAR _hour = HOUR([TimeField])
RETURN
SWITCH(
TRUE(),
_hour>=8&&_hour<=9, 1,
_hour>=7&&_hour<8, 5,
_hour>=16&&_hour<=17, 10,
999
)
Hi @rafiql09
For this you need to add a new calculated column wiht a sintax similar to:
=if Time.Hour([Column1])>=7 and Time.Hour([Column1])<8 then 5 else if Time.Hour([Column1]) >=8 and Time.Hour([Column1]) < 9 then 1 else if Time.Hour([Column1]) >=16 and Time.Hour([Column1]) < 17 then 10 else null
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @rafiql09
My bad the code I sent you was ffor Power Query. Please forgive me the lack of information but glad you already solved it.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for helping me starting it .
I have made the changes and looks ok. But multiple IF giving me error!! Can you help please?
hi @rafiql09
try like:
shift_id =
VAR _hour = HOUR([TimeField])
RETURN
SWITCH(
TRUE(),
_hour>=8&&_hour<=9, 1,
_hour>=7&&_hour<8, 5,
_hour>=16&&_hour<=17, 10,
999
)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |