If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions. Some are easy, but others are much more advanced and can be difficult to use. In this post though, I want to take you back
One thing that can seem like a limitation of Power BI is its calendar date table. Often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in either
We’re going to work through something really unique around Time Intelligence inside of Power BI. This scenario was brought up on the Enterprise DNA Support Forum, where there was a need to compare “like-for-like” within months. In other words, they wanted to compare the first working day in a particular month to the first working
In this tutorial, we’re going to learn how to use Power BI to compare your sales in any particular month to the previous best month you’ve ever achieved. This is a very unique piece of analysis that will give you more insight into what leads to successful outcomes within your organization. Successful businesses will compare
Power BI is an amazing analytical engine! Today I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. In this example I
