Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Business Day Add Using Date Table

Hello   Looking for some helpful dax. I need to return a date that is 30 business days from a known date.    I have two tables in my datasource. Table1 is my main data and i'm using an 'OpenDate'...
DaFloDo's avatar
DaFloDo
Resolver I
7 years ago

hi Anonymous

 

here is an idea how you could try to solve the problem:

- have a serial numbering for only business days (I used RANKX to create a new table, but maybe you have better options?)
- adding a new column that searches for the business day which is 30 ranks higher

After 30 Business Days = 
var currentRank =  DatesRankedByDay[Rank]
var found = calculate( min(DatesRankedByDay[Date]); All(DatesRankedByDay); DatesRankedByDay[Rank] - currentRank = 30)
return found


seems to work ... 

 

regards

 

Florian