Powerbi add number of workdays to current date to return weeknumber

Hi all!

A quick question. I am trying to work with date calculations in powerbi but am not familiar with the code.
I have a column with numbers (x) currently formatted as rounded numbers. I would like two new columns:

Column 1: Today's date + x, not counting saturday and sunday.
Column 2: the week number that the date in column 1 is in

For example, its Friday 28-10 today. Number (x) = 12.
Column 1: 15 nov
Column 2: 46

If there is a way to define other days as non-working days too that would be icing on the cake but please don't skip over the solution that only excludes weekend days, as I think going right to the holidays bit will be too complex for me to understand in one go.

Thanks a lot!

Hi JEC.,

yes, I know that function for "regular" excel formulas and I also understand it enough to be able to use it. There is also quite a lot of information with a simple google search.

For the equivalent in powerquery I find some answers through google but none are beginner-friendly enough for me to get them to work.

edit: ah you included a link, will try now

Here's what I ended up using for calculating the date after x workdays:

= (StartDate as date, WorkDays as number) =>
let
WorkDays2 = (WorkDays*2)+7,
startDate = if Date.DayOfWeek(StartDate)=5 then Date.AddDays(StartDate,2) else
if Date.DayOfWeek(StartDate)=6 then Date.AddDays(StartDate,1) else StartDate,
ListOfDates = List.Dates(startDate, WorkDays2,#duration(1,0,0,0)),
DeleteWeekends = List.Select(ListOfDates, each Date.DayOfWeek(_,1) < 5 ),
WorkDate = List.Range(DeleteWeekends,WorkDays,1),

Result = WorkDate{0}

in
Result


And here is converting it to ISO weeknumbers:

= (Data as date) =>
let
Weekday = Date.DayOfWeek(Data) + 1,
Part1 = Number.From(Data) - Weekday + 11,
Part2 = Number.From(#date(Date.Year(Date.From(Number.From(Data) + 4 - Weekday)),1,1)),
Part3 = (Part1 - Part2) / 7,
Tranc = Part3 - Number.Mod(Part3, 1)
in
Tranc