Forum Discussion
Calendar Visual
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF(TODAY()>=[Start Date]&&TODAY()<=[End Date],1,0)2. Create measure.
vailable = var _noavailable=SUM(Merge[Column]) return COUNT(Dataset1[Employee Name])-_noavailable3. Use the card chart to place the measure in
4. Result:
Today is 2021.9.16. According to the conditions, neither of them is in working hours, so no one today
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
You can find Calendar by MAQ Software in Get more visual.
Here are the steps you can follow：
1. Create calculated table
Merge = UNION('Dataset 2 - Sickness','Dataset 3 - Holiday')
2. Open Calendar by MAQ Software. Visual object, and place the columns of the Merge table below.
3. Result:
When Employee is available on a certain day, the color is not displayed. When Employee is not available on a certain day, it is displayed in the specified color.
This is the relevant information of Calendar by MAQ Software:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381844
https://www.c-sharpcorner.com/article/create-event-calendar-in-power-bi/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
This is great. Is it possible to lay the visual out as follows?
Each day tell me the total amount of employees available (count of dataset 1 - employees with sickness and holiday days)
Many thanks,
E