Power BI Date Dimension; Default or Custom? Is It Confusing?
If you have worked with Power BI for some time, you know that there are two types of the Date dimensions; Custom or built-in/Default. It is always confusing for people, that which date dimension is good to use, and what is the difference between these two approaches. Also based on the selection of the type of Date dimension, your DAX calculations may differ a little bit. In this post, I’ll explain all you need to know about the default and custom date dimension in Power BI and help you to choose the right one for your Power BI solution. If you like to learn more about Power BI, read the Power BI book from Rookie to Rock Star.
Read the rest of the blog post here: https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing
Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views
6 年Great post and explanation?Reza.? I always use a custom calendar and often used to forget to mark it as date table.? ?I'd then be reminded whenever I tried to do a quick measure using my Calendar? "ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.").? ? Marking my Calendar as Date Table fixes that. These days I have saved a Power BI Template containing my Calendar (marked as date table)? and also with month name sorted by month number :)? ?- time saver!?
President / CPO / Founder at Projectworks
6 年Doug Taylor This might be useful
Helps CFO's & Accountants take ?Power Over ??Data using Power BI
6 年Its important to have a good Date Table and understanding really unlocks a lot of complex reporting options for business as you mentioned. I always turn off automatic date time intelligence! I too was confused when first learning Power BI and Dax...Great Tip about removing unused dates in your model, definitely a space hogger...Thanks for the Post Reza
??Scaling GTM Systems & Marketing Operations (MOps)??| ??Driving digital transformation | ?Strategy, Analytics, Project Management, Process improvement, Tool stack management, Marketing automation, GDPR | ????????????
6 年Thanks for this article. I found the date dimension to be one of the most confusing of all the dimensions to figure out.