Havens Consulting
Video by: Reid Havens
Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!
Video by: Reid Havens
Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!
Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.
Explore the features available in Bravo for Power BI: Analyze Model, Format DAX, Manage Dates, and Export Data. In particular, we will see how it is possible to customize and deploy a date table for an entire organization!
Marco Russo wrote several books about DAX and data modeling for Power BI and Analysis Service with Alberto Ferrari. Marco regularly publishes new content on sqlbi.com and teaches DAX around the world.
Bravo for Power BI
SQLBI Website
Marco's Twitter
Marco's LinkedIn
Video by: Reid Havens
Get a complete step-by-step guide to building out a dedicated calendar table and independent date hierarchy (using DAX) in Power BI. Tune in to learn more!
Date Hierarchy Types
DAX Vs. Power Query Date Table
Power Query Dynamic Date Range
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.
