Forum Discussion

azaterol's avatar
azaterol
Helper V
3 years ago
Solved

textfield bevor week

Hello everyone,   I would like to have the abbreviation "CW" for calendar week in front of the number. How can I do that?   My formula to get the calendar weeks displayed: "Weeknum",WEEKNUM([Dat...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago
    Date = 
ADDCOLUMNS (
CALENDAR (MIN(DOC[DocDate]), DATE(2023,12,31)),
"Weeknum","CW"& WEEKNUM([Date],21)
)

     

Ahmedx's avatar
Ahmedx
Super User
3 years ago
Date = 
ADDCOLUMNS (
CALENDAR (MIN(DOC[DocDate]), DATE(2023,12,31)),
"Weeknum","CW"& WEEKNUM([Date],21)
)