Team Leave Calendar - Annual Leave

[Anonymous]

Hi All,

Has anyone been able to successful create a calendar visualisation that shows a teams annual leave and the days they are on leave?

I have downloaded a couple of the calendar visualisation apps but unfortunately doesn't seem to 

Any ideas or suggestions would be great!

Below is the code I have pulled together the dates between a Start Date and End Data in a table as well as the employees name. 

Leave Expanded = SELECTCOLUMNS(
                          FILTER(
    				 CROSSJOIN(Query6,'Date') ,
	           		'Query6'[StartDate].[Date] <= 'Date'[Date]
                                &&  'Query6'[EndDate].[Date] >= 'Date'[Date]
                            ),
                            "Employee Name" , 'Query6'[EmployeeName],
                            "Is On Leave" ,'Date'[Date]
                            )

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[robhel]

Hi @Anonymous

I am currently working on developing a visual employee calendar for leave for over 1500 employees nationally and 30+ type of leave for full time & part time staff - if this is what you are looking for, let me know and I'll provide further details of how I hacked my way through it - which I really do mean hacked 

[ac79]

Hi, 

Can you share how you created it please?

[AnjaliThakkar]

Hi,
Can you please share the query of the calendar you create. I am new to PowerBi , if you could help pls

[beyerse]

Hi Robhel, 

I also need to work on a leave calendar. Would you please let me know how you did it? 

[intisab]

Hello,

Can you please share how did you implement this visual?

[Anonymous]

Hi robhel,

I am trying to achieve a visual which is almost exactly what you have done.  Do you mind sharing with me how you did it?

Thanks,

Andrew

[rosscortb]

Hi @Anonymous @intisab 

I used this link to create below - Link 

A =  Approved Leave

S = Submitted Leave

Names on the left on rows

Thanks Ross

[beyonbabu]

hi there @rosscortb , Can I get that template to download? Thanks

[v-jiascu-msft]

Hi @Anonymous,

What's the expected result? It seems your formula should work. Please download the demo in the attachment. 

1. The solution in a measure.

Measure =
IF (
    MIN ( 'Date'[Date] ) >= MIN ( Query6[StartDate] )
        && MIN ( 'Date'[Date] ) <= MIN ( Query6[EndDate] ),
    "On leave",
    BLANK ()
)

2. The solution in a calculated table.

Table =
FILTER (
    CROSSJOIN ( 'Date', Query6 ),
    [StartDate] <= [Date]
        && Query6[EndDate] >= [Date]
)

Best Regards,
Dale