Forum Discussion
Data modelling
I have a DIM_CALENDAR table in Power BI which is the master data for all dates from year 2020 to 2025. I am creating a relationship between this Dim_Calendar table with Fact_Sales table which has det...
Download example PBIX file with data shown below
I can't reproduce your problem. With my sample data if it is set up correctly with a Calendar that is marked as a Date Table and you have a relationship between the calendar and your dim table, it should look like this
Please supply your PBIX file or some sample data so I can check it for you.
Regards
Phil