Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi fellow members,
I need to solve th following issue:
From a given date I need to obtain the date of thursday of the following week.
Input date | Input day of week | Result | Result day of week |
06/09/2021 | monday | 16/09/2021 | thursday (next week) |
08/10/2021 | friday | 14/10/2021 | thursday (next week) |
13/10/2021 | wednesday | 21/10/2021 | thursday (next week) |
18/10/2021 | monday | 28/10/2021 | thursday (next week) |
Thanks in advance
Solved! Go to Solution.
Hi @renecernitz ,
Try this in a new custom column:
Date.AddDays(Date.EndOfWeek([Input date]), 4)
This gives me the following ouput:
Pete
Proud to be a Datanaut!
Hi @renecernitz ,
Try this in a new custom column:
Date.AddDays(Date.EndOfWeek([Input date]), 4)
This gives me the following ouput:
Pete
Proud to be a Datanaut!
Suggest you specify the `firstDayOfTheWeek` argument as `Day.Monday`.
If I don't do that, your formula returns the next Wednesday. Possibly due to my regional settings which have Sunday as the first day of the week.
Or, better yet, ask the OP when his week starts, and adjust accordingly.
Hi @ronrsnfld ,
Thanks for the suggestion.
If the necessary correction was more difficult than changing one number then I might have done so.
Pete
Proud to be a Datanaut!
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
15 | |
14 | |
8 | |
6 | |
6 |