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

MAQSupport's avatar
MAQSupport
Solution Supplier
4 years ago

Hello,

                                                   

We offer building custom visuals or enhancing existing visuals. Based on your asks and attached mock-up we will be able to build a custom visual for your needs.

 

If you have an urgent need for a custom feature or visual, please contact [email protected]