In this tutorial, you’ll learn how to remove a hidden date table in Power BI to reduce RAM usage and improve performance. Power BI automatically creates hidden date tables when you have the Auto date/time option enabled. To enable the Auto date/time, go to Options and then to the Data Load tab. Under the Time
Tag: Time Intelligence
In this blog post, we will deal with some troublesome issues in time intelligence, particularly those issues caused by week granularity and the troubles that can be caused by the irregular number of weeks in a year. We’ll use offsets to come up with accurate time intelligence in DAX. We have an interesting scenario for
Power BI can help you build dynamic and customizable applications that can be embedded within organizations and transform the way things are analyzed. In this post, I wanted to showcase the comprehensive nature of Enterprise DNA’s learning platform, which feature hundreds of videos and numerous courses to help you learn Power BI. We wanted to
In this blog post, I’ll be bringing you the solution for working with timetables in Power BI, which is our Problem of the Week #10. This wasn’t an overly difficult challenge. But still, it was quite a niggly one that threw in quite a few curveballs. You can watch the full video of this tutorial
In this blog I’ll show you how you can compare data from different timeframes within the same visualization. You can get amazing Power BI insights using this great technique with time-related DAX. You may watch the full video of this tutorial at the bottom of this blog. I discovered this approach from the Enterprise DNA