Forum Discussion

MichaelG1117's avatar
MichaelG1117
Icon for Helper I rankHelper I
2 years ago
Solved

Creating Date Table With "Week Number" Column Without Using Calculated Columns

I can create the AutoCalendar Date Table but need to create one that includes a "Week Number" column also. I cannot use a calculated column so I need to know the language to create the table from scr...
  • Dangar332's avatar
    Dangar332
    2 years ago

    HI, MichaelG1117 

    use addcolumn() function 

    ADDCOLUMNS (
    CALENDARAUTO (),
    "weeknum",weeknum(tablename[datecolumn])
)
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

HI, MichaelG1117 

use addcolumn() function 

ADDCOLUMNS (
    CALENDARAUTO (),
    "weeknum",weeknum(tablename[datecolumn])
)
MichaelG1117's avatar
MichaelG1117
Icon for Helper I rankHelper I
2 years ago

thanks!