Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |