Skip to content
Home » date

date

Visit Tacticalware.com for information related to this tag and others. We look forward to assisting in your tech projects with our in-depth knowledgebase…

POWER BI – DISABLE DATE/TIME HIERARCHY

  • Power BI

Sick of your system being bogged down by the overhead of the autocalculations for the Date/Time fields. Here is how you disable that feature:

Inside Power BI
Go to File
Click Options and Settings
Select Options
Find GLOBAL and look at the options below it
Select Data Load
Uncheck Auto date/time for new files
Find CURRENT FILE and look at the options below it
Select Data Load
Uncheck Auto date/time

POWER BI CALENDAR / DATE TABLE

  • Power BI

If your data warehouse does not have a date table or a time table, how do you create it within Power BI….well here you go

In Power BI
Click the Modeling tab
Select New Table
Type in:
Calendar = CALENDARAUTO(6)


Note:
CALENDAR – You will supply the Start and End Date
CALENDARAUTO – Looks through all the dates in the model and automatically builds out the range. If your model begins on July 15, 1979 and your fiscal year end is June 30th, if you set CALENDARAUTO(6) it will allow all dates from July 15, 1979 to June 30, 2021. If you leave CALENDARAUTO() blank, it will go to the end of the year (December 31).