Forum Discussion

hm13's avatar
hm13
Frequent Visitor
3 years ago
Solved

Single-column dimension table

I just started PowerBI a couple weeks ago. I've been looking at explanations and videos for star schema, but I haven't seen any example where they use single-column dimension tables. It is usually mu...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi hm13 

     

    You just need only two tables: one calendar table (to manage correctly dates) and your fact table will be this one ( Date, Time, Name, Process, Shift, Location, and Description).

     

    Now you relate Date column with Calendar table (date). The relationship should be 1 to * (* this in the part of the Table with your data). Your model should be something close to this:

     

     

    And now, in the slicers you just need to put the column needed. 

ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
3 years ago

If your data model will only consist of one single table, then there is no point in creating a star schema. If you'll have multiple tables, then yes, star schema is a good idea.