Calendar with condition

Question

Hi all,I have Calendar created like the below:&nbsp;DimDates = VAR BaseCalendar =&nbsp; &nbsp; &nbsp; &nbsp; CALENDAR(DATE(2023,1,2), TODAY())RETURN&nbsp; &nbsp; &nbsp; &nbsp; GENERATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BaseCalendar,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR BaseDate = [Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR YearDate = YEAR(BaseDate)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR Week = WEEKNUM(BaseDate,21)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ROW (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year",YearDate,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "YearMonth",FORMAT(BaseDate,"yyyy-mm"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "YearWeeknumber", FORMAT(BaseDate,"yyyy") &amp;"-"&amp; FORMAT(WEEKNUM (BaseDate,21),"00"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Weeknumber", "W" &amp;"-"&amp; FORMAT(WEEKNUM (BaseDate,21),"00")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &nbsp; &nbsp;&nbsp; &nbsp; )&nbsp;&nbsp;Basically nothing special, but as you can see I'm using format week = 21 means that year 2025 starting 2024-12-30. I need to change column Year for 2024-12-30 and&nbsp;2024-12-31 to be Year 2025 and not 2024. Only these two dates are wrong. Is there any special format for year?&nbsp;Maybe put some conditions into calendar DAX?Thank you for your help.&nbsp;

lbendlin · Accepted Answer

Calendars are immutable. There is no point in doing this in either DAX or Power Query&nbsp; (apart from a nice finger exercise).&nbsp; Use an external reference table that has all the required quirks precomputed.

Forum Discussion

Calendar with condition

1 Reply

Related content

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Weeknum as per Calendar

Calendar Issue loading stuck