Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calendar Visual

Hi All,   I am trying to create a calendar visual that shows the total number of employees on site on any given day.   Dataset 1 - All employees who should be available on any given day. Empl...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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])-_noavailable

    3. 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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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])-_noavailable

3. 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