Missing sales in the first week of each year

[Greg]

Hi @kjssdca. I took a quick look, and your model and DAX measures are fairly straightforward, so I’d suspect something is wrong with your Dates table. I can’t see the source code for the [Dates] table, so can’t decipher further. Perhaps you could either try to reset your [Dates] table code with the latest from the eDNA source,

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…

or cut-and-paste the source code currently being used for your [Dates] table.

In any event, I saw 2 things to do before going further:

• mark [Dates] table as a data table
• sort Dates[MonthInCalendar] by Dates [MonthnYear]

Greg