Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

To create a shift roaster in Power BI

Hi All, I have a requirement to create a shift roaster in power BI, below is the format given in Weeks. I have to display Weeks along with timing PST and highlight the shift details during this tim...
Need Help
HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
5 years ago

Anonymous you can create a custom calender .

Calender = ADDCOLUMNS( CALENDAR(MIN(data[Order Date]),MAX(data[Order Date])),
"Year",YEAR([Date])
, "Monthnum",MONTH([Date]),
"Month Name ", FORMAT([Date],"mmmm")
, "Day", DAY([Date]),
"Day Name", FORMAT([Date],"dddd"),
Then drag the required feild in matrix for result like this 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply but this data is coming from a Strored Procedure so I cannot modify it.

Can you tell me how well can I represent a shift roaster in Power BI which shows the associates working in which shift weekly.