A recent question came out of the Enterprise DNA Support Forum where a member needed to work out what was the top value that they had for a particular result. You can review the entire forum post here – Product Name as Measure for Highest Sales Product They didn’t require just any value. They actually
Tag: CALCULATE DAX
We are going to go through quite an advanced tutorial here utilizing DAX formulas in Power BI What I want to show you is how we can work out; how many sales we have made from a specific customer….but, we only want to look at the last three sales or last N number of sales rather
Occasionally when running analysis in Power BI, you may need to take into account weekends or public holidays where there is no data. When there is no data, it can make your visualizations look a little bit off. That’s where this normalizing technique comes into play…where you might need to normalize, for example, sales amounts
As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost
In this example, we’re doing a deep dive into budgeting and forecasting inside of Power BI. Specifically, I want to show you how you can allocate budgets (or forecasts) which might be at a monthly or a yearly level, and you need to allocate them to a daily level. This scenario is very common when