Forum Discussion

acnt_schartner's avatar
acnt_schartner
Icon for Helper III rankHelper III
5 years ago
Solved

Looking for real year-week

Hi,   i have a dax created calender    1_Param_Dates = VAR Days = CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2021, 12, 31 ) ) RETURN ADDCOLUMNS ( Days, "Year", YEAR ( [Date] ), "MonthNumber", ...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    acnt_schartner 

     

    I have amended the year formula. Please see below

     

    Year = IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date]))

     

    YearWeek = IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date])) & "-" & WEEKNUM('Calendar'[Date], 21)
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

acnt_schartner 

 

I have amended the year formula. Please see below

 

Year = IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date]))

 

YearWeek = IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date])) & "-" & WEEKNUM('Calendar'[Date], 21)
acnt_schartner's avatar
acnt_schartner
Icon for Helper III rankHelper III
5 years ago

Thats it. Thank you.