Direct Lake Weekly fields in Calendar table cause duplicated values when combined

[Fdc88]

Hi everyone,

I’m running into a reproducible issue in Direct Lake when using a Calendar table with or without ISO week logic.
Whenever I use two weekly period fields together in a visual, for example:

• WeekCode (ISO YYYYWW)

• WeekStartDate (ISO Monday of the week)

…the measure values duplicate, even though both columns represent the same ISO week.

This happens even when the table is 100% ISO-correct and the data is verified...

WeekCode (Calendar table):

WeekStartDate (Calendar table):

WeekCode + WeekStartDate:

[Fdc88]

Issue raised:

https://community.fabric.microsoft.com/t5/Issues/Direct-Lake-Weekly-fields-in-Calendar-table-cause-d...

[lbendlin · Accepted solution]

Consider raising a ticket

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .