Running time comparison type analysis on custom calendars is a little bit more complex than if you were using a standard calendar. The reason behind this is because the time intelligence functions available for custom calendars allow users to quite easily and effectively write a formula and achieve the results that they want. Unfortunately with non-standard
Calculating the difference between weekly sales results in Power BI is unfortunately not that easy. The reason behind this is that Power BI doesn’t have a weekly-based built-in time intelligence function. The only available options are for the day, month, quarter, and year. I’ll show you with the DATEADD function in this formula. This function
The next learning summit is not far away. We’re expecting a large turnout and have some exciting sessions planned. Already we now have close to 1000 Power BI users registered for the event. There will be plenty of new and interesting content that will be covered during this summit. The best thing about it is
In this tutorial, I go through an average results analysis technique. I dive into some types of procurement & purchasing analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may make. I go through which DAX formula combination you need to be able to
In this tutorial, we’re going to dive into some procurement analysis or purchasing decision-making within organizations. This tutorial demonstrates the versatility of Power BI when it comes to helping make insightful decisions for a procurement division. I’m going to run through an intro example where we’ll start from raw data, create a quick data model,
