Dimension Table

[Greg]

Hi @Rohit1.

This is exactly the scenario used in data modelling workout #1 posted on the forum back in April. Here’s a link to my write-up:

Data Modelling Workout 01 - Star Schema

Here’s the notes I kept during the development of my solution to this workout. Pre-Modelling Activities - General: • create new, empty PBIX • use File\Options\Options and settings\Global\Data Load\Time intelligence to ensure Auto Date/time for new files is disabled • use File\Options\Options and settings\Current File\Data Load\Time intelligence to ensure Auto Date/time is disabled • use File\Options\Options and settings\Current File\Data Load\Relationships to ensure Autodetect new relationshi…

Hope it helps.
Greg