Menu

  • About Me
  • Event Schedule
  • Copyright

Martin's Blog

Power Query



Every Power BI model needs a Date entity

Martin Schoombee

1 comment

February 5, 2018

Unless your source data contains no dates at all, every Power BI model should have a Date entity. Chances are good that you’ve ignored a built-in option in Power BI Desktop that’s enabled by default (image below). While the “Auto Date/Time” option isn’t the worst thing you could do in Power BI Desktop (i.e. the …

Continue reading

Categories: Business Intelligence, Power BI, Power Query•

Connect & Follow

  • X
  • LinkedIn

Subscribe

Enter your email address to follow this blog and receive notifications of new posts by email.

Categories

Administration Azure Data Factory Business Intelligence Career ETL General O365 Power BI PowerShell SQL Server

Other Posts You’d Like

  • Working with OAuth 2.0 APIs in Azure Data Factory: Refreshing tokens
  • Working with OAuth 2.0 APIs in Azure Data Factory: Using Postman to get tokens and test API requests
  • Working with OAuth 2.0 APIs in Azure Data Factory: The ADF linked service and dataset
  • Working with OAuth 2.0 APIs in Azure Data Factory: A series
  • Create a calendar view with the matrix visual in Power BI
  • Working with OAuth 2.0 APIs in Azure Data Factory: The authorization flow
  • A user-friendly way to deal with role-playing dimensions in Power BI
  • Automating Power BI deployments: Deploying reports
  • Working with OAuth 2.0 APIs in Azure Data Factory: Extracting data
  • Automating Power BI deployments: Connecting to the service

Archives

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Powered by WordPress.com.

 

Loading Comments...