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,...
You need a proper date table, There's plenty of articles, videos and tools which can help create one.
In your case, do not create a relationship from the date table to the fact table, as the facts relate to date ranges rather than specific dates.