Enabling Time Intelligence

Time Intelligence is a very powerful DAX feature that allows you to easily write calculations that refer to time periods, such as Month to Date, Previous Year, etc. To enable Time Intelligence, you need to tell Power BI which is the date dimension.

  1. Click on the Date table

  2. Under Table Tools Tab > Click on Mark as Date Table dropdown > Select Mark as Date Table Mark as Data Table

  3. Set the Date Column to Date
    Set Date Column

  4. The Date column should now look like this:
    Final Look

Power BI creates its own date table for each date found in your dataset. This can bloat the size of your file. Best practice is to switch this off.

  1. Go to File tab> Click on Options and settings > Click on Options

  2. Select Data Load tab in CURRENT FILE section, uncheck Auto Date/Time

UncheckAutoTime