Forum Discussion
Solved
Object State Display Problem by Period in Power BI
I am working on a dynamic display of object states in Power BI based on a time logic, similar to snapshots taken at different periods (in this case, weeks). My source table contains, for each object,...
johnt75, Actually, I don’t have a week column in my fact tables — I derive it from the start and end dates.
My issue with the measure that’s supposed to duplicate rows is that it doesn’t actually do that. For example, if I have two IDs that are present in two different weeks, they should appear twice: one row for the first week, another for the second. And if I select more weeks, the row should be duplicated as many times as there are relevant weeks — but that’s not the case.