topic Re: Working days plus one in DAX Commands and Tips

Working days plus one

jimpatel — Tue, 07 Nov 2023 15:12:29 GMT

Hi,

thanks for looking at my post.

I have a date column and i wanted to add one working date to it please.

That is Date column (not necessary today's date) + one working date please?

Any idea please?

Re: Working days plus one

jpessoa8 — Tue, 07 Nov 2023 15:57:29 GMT

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

Re: Working days plus one

jimpatel — Tue, 07 Nov 2023 17:29:08 GMT

Much appreciated for your kind help.

Thanks a lot 🙂

Re: Working days plus one

jimpatel — Mon, 20 May 2024 13:06:31 GMT

Hi,

Sorry for reopening this post.

What should i do if i need to add date plus 40 days (excluding weekends please)

Formula does not work correctly for adding 40 days from date (which will be different dates) and excluding weekend please?

Any idea please

thanks a lot 🙂