In this tutorial, we’ll dive into one of the most advanced DAX functions in Power BI called the TREATAS function. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you’ll be creating inside Power BI. TREATAS allows us to simplify our model but
I want to show here how incredible Power BI is as an analytical tool. I’ll teach you how to develop a Power BI data model for an advanced scenario analysis. With Power BI, we can achieve so much that we might never have thought possible. Developing scenario analysis logic within a Power BI data model
The possibilities of using the What If parameter in Power BI is deemed endless. It gives users and businesses the flexibility to design a solution for the critical answers and insights that they need. In the recent Enterprise DNA learning summit, we had a successful session regarding the usage and implementation of What If Parameter
In this tutorial I run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI. I’m talking about forecasting product demand. Power BI is an amazing tool for data analysis when you can implement techniques like this one. Take a situation where you want to analyze future
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
