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

Question

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 Answer

HI,&nbsp;MichaelG1117&nbsp;use addcolumn() function&nbsp;ADDCOLUMNS (
    CALENDARAUTO (),
    "weeknum",weeknum(tablename[datecolumn])
)

Forum Discussion

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

2 Replies

Related content

"synchronized" week number across different years

Dynamic Date Grouping (by Week number) with "Before" label

Issue with Date slicer that contains "Last Completed Week" and "Current Week" as values

MoM calculation

Calculation Help