Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Labour Availability

Hi,   I am using the Custom Calendar visual by Akvelon to show a labour profile of available labour on any given day in the month.   Dataset 1 My first dataset includes a list of every employee ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could use custom calendar

    unfortunately it don't have tooltip. like below:

    1.create a calendar table.

    Table = CALENDAR(DATE(2021,1,1),DATE(2021,12,31))

    2.create a measure.

    Measure = 
DISTINCTCOUNT('Table1'[employee name])-
CALCULATE(DISTINCTCOUNT(Table2[employee number]),FILTER(ALL(Table2),[start date]<=MAX('Table'[Date])&&[end date]>=MAX('Table'[Date])))&"  available"

    The final output is shown below:

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could use custom calendar

unfortunately it don't have tooltip. like below:

1.create a calendar table.

Table = CALENDAR(DATE(2021,1,1),DATE(2021,12,31))

2.create a measure.

Measure = 
DISTINCTCOUNT('Table1'[employee name])-
CALCULATE(DISTINCTCOUNT(Table2[employee number]),FILTER(ALL(Table2),[start date]<=MAX('Table'[Date])&&[end date]>=MAX('Table'[Date])))&"  available"

The final output is shown below:

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.