Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Crossfilter using a bridge table

Hello, I have a bridge table that shows for each Year&Month combo how many works days there are for each state we have offices.  The reason for this table is if there is snow in Colorado they may ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Please check my pbix below.

    In my example, employee "a" has time off 15 hours in 2019/3,

    he belongs to state 111 where has snow 2 weather day and it is in workday(Monday to Friday),

    Basically, for 2019/3, there is 21 workdays (exclude the Saturday and Sunday), assume each day's working hours is 8 hours, 

    then employee "a" should working 168(21*8) hours in 2019/3,

    with the snow weather affeacted, his real working hours is 137 hours(168-2*8-15).

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Please check my pbix below.

In my example, employee "a" has time off 15 hours in 2019/3,

he belongs to state 111 where has snow 2 weather day and it is in workday(Monday to Friday),

Basically, for 2019/3, there is 21 workdays (exclude the Saturday and Sunday), assume each day's working hours is 8 hours, 

then employee "a" should working 168(21*8) hours in 2019/3,

with the snow weather affeacted, his real working hours is 137 hours(168-2*8-15).

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.