Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create an oncall calendar in power BI and display it in the regular calendar format. Any ideas on how do i go about it?
Below is the snippet of the raw data:
Dates | John | David | Aaron | Jack | Sandy | Name | Phone number | Events | |
11/21/2020 | On Call | Weekend | Weekend | Weekend | Weekend | John | +1 203 | On Call | |
11/22/2020 | Weekend | On Call | Weekend | Weekend | Weekend | David | +1 203 | Weekend | |
11/23/2020 | Working | Working | On Call | Working | Working | Aaron | +1 203 | Working | |
11/24/2020 | Working | Working | Working | On Call | Working | Jack | +1 203 | Holiday | |
11/25/2020 | Working | Working | Working | Working | On Call | Sandy | +1 203 | ||
11/26/2020 | On Call | Holiday | Holiday | Holiday | Holiday | ||||
11/27/2020 | Holiday | On Call | Holiday | Holiday | Holiday | ||||
11/28/2020 | Weekend | Weekend | On Call | Weekend | Weekend | ||||
11/29/2020 | Weekend | Weekend | Weekend | On Call | Weekend | ||||
11/30/2020 | Working | Working | Working | Working | On Call | ||||
12/1/2020 | On Call | Working | Working | Working | Working | ||||
12/2/2020 | Working | On Call | Working | Working | Working | ||||
12/3/2020 | Working | Working | On Call | Working | Working | ||||
12/4/2020 | Working | Working | Working | On Call | Working |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.