Forum Discussion

PaulMac's avatar
PaulMac
Helper IV
2 years ago
Solved

Converting a simple Formula to Work in Power BI

Hi   We have a very simple formula in an Excel workbook:   =WORKDAY($A2,9,BankHolidays)   This takes the date that sits in cell A2, adds on 9 working days, excluding any Bank Holiday dates th...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    PaulMac,

     

    Try this calculated column in Table1. It requires a Dates table with columns Is Weekday and Is Holiday.

     

    10 Day Letter Due =
VAR vDaysToAdd = 9
VAR vStartDate =
    Table1[Date Received]
VAR vWorkdaysAfterStartDate =
    FILTER (
        Dates,
        Dates[Date] > vStartDate
            && Dates[Is Weekday] = 1
            && Dates[Is Holiday] = 0
    )
VAR vResult =
    MAXX (
        TOPN ( vDaysToAdd, vWorkdaysAfterStartDate, Dates[Date], ASC ),
        Dates[Date]
    )
RETURN
    vResult