Tag: CALCULATE DAX

Showcase The Top Result Name Within A Card Visualization Using Power BI

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

Continue reading

Show Last N Sales Of A Customer Only Using Power BI

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

Continue reading

Normalizing Results On Different Days In Power BI Using DAX

Normalizing Results On Different Days In Power BI Using DAX

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

Continue reading

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

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

Continue reading

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

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

Continue reading