Havens Consulting
Video by: Reid Havens
Learn about two primary Hierarchy types you can implement on a Date Table in Power BI. I consider it a best practice to include dependent and independent date hierarchies, which can impact how users want to navigate the hierarchy controls in visuals.
Video by: Reid Havens
Learn how to create a composite model against a Power BI dataset, also known as (DirectQuery for Power BI datasets and Azure Analysis Services) or DQFPBIDAAS for short. 😅
Composite Models against a Power BI Dataset allows you to import tables from other data sources and combine it with your Power BI dataset.
Splitting a Report & Model
DirectQuery for Power BI datasets and Azure Analysis Services
DAX.do is an online service to play with DAX using just a web browser. DAX.do is mainly a learning tool, but it is also a way to share DAX code and quickly test a DAX expression with a standard sample model (Contoso). If you have any questions about DAX.do, or want to know more about why it exists and the architecture behind it, join this live session with Marco Russo, one of the DAX.do authors. In preparation for the live event, you can also watch the DAX.do – Behind the scenes video at the link below!
Video by: Reid Havens
Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
