Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

working days calculation

Hi, I'm looking for a calculation to perform a task that would give me a number of working days for each employee. Below is the sample data   Emp name Created Date Monday Tuesday Wednesda...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , a new column like

    if([Monday]>0,1,0) + if([Tuesday]>0,1,0) + if([Wednesday]>0,1,0) + if([Thursday]>0,1,0) + if([Friday]>0,1,0) + if([Saturday]>0,1,0) + if([Sunday]>0,1,0)

     

     

    Another way is to unpivot the weekday's column

    https://radacad.com/pivot-and-unpivot-with-power-bi

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , a new column like

if([Monday]>0,1,0) + if([Tuesday]>0,1,0) + if([Wednesday]>0,1,0) + if([Thursday]>0,1,0) + if([Friday]>0,1,0) + if([Saturday]>0,1,0) + if([Sunday]>0,1,0)

 

 

Another way is to unpivot the weekday's column

https://radacad.com/pivot-and-unpivot-with-power-bi