Forum Discussion
All Friday's date as week Number
Hi,
I have column with dates and in new column Next Friday date as week number, i mean week ends on Friday.
Date | Week # | Comments |
5/5/2018 Sat | Week - 11 | Next Friday date |
5/6/2018 Sun | Week - 11 |
|
5/7/2018 Mon | Week - 11 |
|
5/8/2018 Tue | Week - 11 |
|
5/9/2018 Wed | Week - 11 |
|
5/10/2018 Thu | Week - 11 |
|
5/11/2018 Fri | Week - 11 |
|
5/12/2018 Sat | Week - 18 |
|
5/13/2018 Sun | Week - 18 |
|
5/14/2018 Mon | Week - 18 |
|
5/15/2018 Tue | Week - 18 |
|
5/16/2018 Wed | Week - 18 |
|
5/17/2018 Thu | Week - 18 |
|
5/18/2018 Fri | Week - 18 |
|
5/19/2018 Sat | Week - 25 |
|
5/20/2018 Sun | Week - 25 |
|
5/21/2018 Mon | Week - 25 |
|
5/22/2018 Tue | Week - 25 |
|
5/23/2018 Wed | Week - 25 |
|
5/24/2018 Thu | Week - 25 |
|
5/25/2018 Fri | Week - 25 |
|
Any suggestion with Dax Formula?
1 Reply
FloriankxSolution Sage
Do you mean something like:
=VAR DaysToFriday=5-WEEKDAY([Date];2) VAR Offset=IF(DaysToFriday>=0;DaysToFriday;7+DaysToFriday) RETURN FORMAT([Date]+Offset;"ddd, dd.mm.yyy")