Forum Discussion
Biweekly Dates Not working properly
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.
Maybe you can clear up where the function comes from?
The algorithm may have worked for 2021 but doesn't work for 2022 (I don't know whether that is true). Another thing is that normally a function like this would be used on a calendar table i.e. not on a Fact table, this is important because some of these DAX calls don't work properly unless that table contains all dates.
I can explain why Jan 10 returns the value it does but I'm not going to wade in to fixing it because it would just be tinkering
-----
Have a think about these things and tell me what you want to do
I figured that all I need to do was
VAR _WkNum = WEEKNUM ( _Date )+1I am pretty new to PBI and I am not to sure about the difference between fact table and calendar table. I never heard of the latter. Thanks for the first post anyways