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

[MichaelG1117]

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 scratch (either in Power Query or Dax). 

Any help would be greatly appreciated. 

Thanks,

Michael G. 

[Dangar332 · Accepted solution]

HI, @MichaelG1117 

use addcolumn() function 

ADDCOLUMNS (
    CALENDARAUTO (),
    "weeknum",weeknum(tablename[datecolumn])
)

[MichaelG1117]

thanks!