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'...
GarryFarrell's avatar
GarryFarrell
Advocate III
7 years ago

Hi,

 

Have you seen the NEXTDAY function? You could use this function inconjuction with your flag. You will need to add some logic to skip the "0" dates.

 

 =CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), NEXTDAY('DateTime'[DateKey]))

 

Garry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Garry. I can't really put that solution together with my problem. 

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    Have you solved your problem?

     

    If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry