Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is
In this tutorial, I will show you how you can get started with ‘What If’ parameters inside of Power BI. Using this great feature will require you to spend some time thinking quite deeply about the data setup that you currently have in your data model. ‘What If’ parameters have to work over certain values
In this example, I dive into one of the most advanced DAX functions in Power BI called TREATAS. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you might be creating inside of Power BI desktop. TREATAS will helps greatly in the simplification of
In this video tutorial, I will showcase some of the analytical work I enjoy completing the most in Power BI..that is working on future predictions. I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future profitability and one that
In today’s video tutorial, I am going to run through some great scenario analysis techniques and also demonstrate to you how you can combine several of them in Power BI. 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
