If there exists a book of ten commandments for Power BI, one of the commandments will be — always have a date table.
A date table is a table that has just dates, and maybe any derivative of a date (month, quarter, year etc.)
Why do you need a date table?
Two easy/quick reasons:
- You have many tables with date columns in each. It is better to have one table to include all the date periods you need and be related to all these other tables.
- Even if you have just one table, as long as that table can have date gaps or 1900 for some records or 2090 for some records; you’ll want to have your own better controlled date table rather than battle endlessly with wrong date entries in source data table. This is common when old data are migrated from a legacy tool.
And to join our training class, visit https://urbizedge.com/powerbi