Working days plus one

Hello jimpatel ,

Are you talking about a implementation in PowerBI as a Calculated Column or in PowerQuery?

For the first option, you can use a validation formula and add the number of days accordingly, like :

DatePlus1= 
SWITCH(TRUE(),
          /*If Date+1 is Saturday, add 3 days*/  WEEKDAY( 'Table'[Column1] + 1,1) = 7 , 'Table'[Column1] + 3,
          /*If Date+1 is Sunday, add 2 days*/  WEEKDAY( 'Table'[Column1] + 1,1) = 1 , 'Table'[Column1] + 2,
          /*Else Date+1*/ 'Table'[Column1] + 1
)

This will work for business days, but only if excluding weekends. Another implementation for holidays would have to be planned, depending how you have that information in your dataset.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa