Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hasan_iba
Helper II
Helper II

Assigning Shift Number according to time of the day

Hi. Power BI Experts. Hope you all are doing well! I am currently facing an issue. I want to assign shift number according to time of the day. For example, the shifts are the following: 

 
The SHIFT is the period of time during the day that the employees works
In Theory there should be like this.
Shift 1 : works from 11pm to 7am
Shif2 : works from 7 am to 3pm
Shif 3 : works from 3pm to 11 pm
 
Now, if I have the following time which is just a portion of my huge database, how can i assign shift number as per the time of the day? I tried vlookup but not working. Any prompt solution will be highly appreciated. Thanks. 
Untitled.png
 
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Hasan_iba,

 

Here is an example for your reference.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Hasan_iba,

 

Here is an example for your reference.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.