Forum Discussion

eburke's avatar
eburke
Icon for Helper II rankHelper II
9 years ago

Calculating work days with different RDOs

Hi all,   Very new to Power BI here so please bare with me.  I have a calendar which has work days/ non work days set up as 1 and 0 based on public holidays and weekends.  However I can't apply thi...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

eburke,

 

For your Employee table, do you have a column to show if current employee who has every Monday as an RDO?  If you have a such column, you can use IF function to get the value from Work Days Norm for employees with no RDOs and get value from MondaysOff for employees who have every Monday as an RDO.

https://msdn.microsoft.com/en-us/library/ee634824.aspx

 

If this is not what you want, please elaborate your requirement, so that we can make further analysis.

 

Regards,

Charlie Liao

  • eburke's avatar
    eburke
    Icon for Helper II rankHelper II
    9 years ago

    Thank you, I'm still not sure what I need in the employee table to link it to the calender table and show when they have an RDO.  Currently my Emplyee table looks like this:

     

    Provider IDAdvisor %Hours pdCalendar
    10111922100%7.6FridaysOff
    10112490100%7.6Working Days Norm
    10113545100%7.6Working Days Norm
    10112128100%7.6Working Days Norm
    10241789100%7.6Working Days Norm
    10116201100%7.6Working Days Norm
    10115537100%7.6Working Days Norm
    10113847100%7.6Working Days Norm
    10114456100%7.6Working Days Norm
    10115501100%7.6Working Days Norm
    10113322100%7.6Working Days Norm
    10112749100%7.6WednesdaysOff
    10262115100%7.6Working Days Norm
    10113873100%7.62ndMonday
    10131994100%7.6Working Days Norm
    10251615100%7.6Working Days Norm
    10113238100%7.62ndThursday
    10113689100%7.6Working Days Norm
    10132550100%7.6Working Days Norm
    10252780100%7.6Working Days Norm
    10114178100%7.6Working Days Norm
    10111591100%7.6Working Days Norm
    10129156100%7.6Working Days Norm
    10113413100%7.6FridaysOff
    10238025100%7.6WednesdaysOff

     

    How do I link this to my calendar table?  Once linked how do I write the IF function to deal with the different RDOs?  Sorry I'm a bit overwhelmed by it all.  Thanks, Emma.