Forum Discussion
Biweekly Dates Not working properly
Hallo, I am trying to merge a bunch of dates into bi weekly periods. I used the following function: Bi-Weekly Date =
VAR _Date = 'Merged Data'[Timesheet Entry: Date]
VAR _WkNum = WEEKNUM ( ...
Guessing that you didn't write the function yourself because there's an explicit test to see what's bigger, the start of the year or the week start. It effectively starts a new period when it's a new year.
Remove the start of the year stuff for starters and see what that gets you.
Guessing that you didn't write the function yourself because there's an explicit test to see what's bigger, the start of the year or the week start. It effectively starts a new period when it's a new year.
Remove the start of the year stuff for starters and see what that gets you.