I’d like to present the best practices I’ve adopted while preparing Power BI reports. Over the past few years, I’ve consumed many online resources on data loading and transformation which have been instrumental in my journey, but I’ve quickly become overwhelmed by the content, so I ended up making my own notes. You may watch
In today’s blog post, I’d like to discuss what we like to call the period table. The period table creates a distinct date range so you can slice your data any way you want. I’ll show you how you can create a dynamic date slicer in Power BI by using this period table. You may
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
In today’s blog, I’ll discuss a question that comes up all the time in the Enterprise DNA forum. How can you can sort the fields from an extended date table columns properly? You may watch the full video of this tutorial at the bottom of this blog. This refers to the extended date table from
In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. The developer
