Forum Discussion
Direct Lake Weekly fields in Calendar table cause duplicated values when combined
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:
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 .
2 Replies
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 .
