Script Calendar Table with offset columns

[BrianJ]

@JoaoMonteiro,

Here you go:

Extended Date Table (Power Query M function)

Hi everyone, To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! // August 2022 There has been an overhaul of the M code from when it was initially shared. This affects column names and values. In the Analyst Hub (follow this link) you can copy a version of Extended Date table which returns a r…

• Brian

P.S. Here’s a link to a helpful Cheat Sheet to accompany the Extended Date Table above:

New Cheat Sheet for Extended Date Table

Extended Date Table Fans, I’m pleased to announce the release of the new deluxe version of the Extended Date Table Cheat Sheet, an essential accompaniment to @Melissa’s awesome and recently revised Extended Date Table code. Click here to obtain the new version, which now includes not only all the field names and examples for each, but field type and information on how to sort every field in the table. We will update this with every major update @Melissa makes to the date table code. We hope…