How to add n business days to date using DAX

[vyny17]

Hi there!

Here is the thing, i have a table with a date column and I want to create a new column adding 5 or 7 business days  to it, depending on some conditions.

I've also heard that there's this "new" function NETWORKDAYS( ), i thought I could use it somehow but it doesn't seem to solve my problem.

What can I do? 😄 

[vyny17]

Thx bro! You saved me!!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@vyny17 

maybe you can try this

5 businessday = if('Table'[Column]=6,'Table'[Date]+6,if('Table'[Column]=7,'Table'[Date]+5,'Table'[Date]+7))

7 businessday = if('Table'[Column] in {1,2,3},'Table'[Date]+9, if('Table'[Column]in {4,5},'Table'[Date]+11,if('Table'[Column]=6,'Table'[Date]+10,if('Table'[Column]=7,'Table'[Date]+9))))

pls see the attachment below