Calculate Next_Business_Day based on multiple columns from different tables.

[sk007]

I want to calculate the required date as shown in the picture. 

I've already made the calendar table and calculated if_work_day (business day for a particular date). 

Date and if_work_day field comes from Calendar Table and rest of the fields comes from another table (TableA)

Logic is like this: 

If pay_frequency = bi_weekly && if pay_frequency = weekly: 

       required_date = end_date + 1 work day (only if_work_day in the next date is 1, if_work_day in the next date is 0, add another next date where if_work_day is 1)

if pay_frequency = semi_monthly && if pay_frequency = monthly:

      required_date = check_date - 3 work day (only if_work_day in that previous date is 1, if_work_day in the previous date is 0, go to another previous date where if_work_day is 1)

How do I calculate this in PowerBI? 

[amitchandak]

@sk007 , refer my blog for that

Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...

Column example is there in the comments 

[Anonymous]

Hi @sk007 ,

Has this question been solved? If you have solved it, you can post your solution here. If any of the responses were helpful to you, please consider marking them as solutions, which will help more users find similar problems faster. If the problem is not solved, please feel free to let us know. Thanks in advance!

Best Regards,
Gao
Community Support Team