Category: DAX

Understanding your customer better with Power BI

Latest post on the Power BI community site was recently released. Navigate there via the below link. http://community.powerbi.com/t5/Community-Blog/bg-p/community_blog Also, the most recent webinar in our series was dedicated to running through the numerous techniques used to develop this solution. You can view it at our youtube channel. https://www.youtube.com/watch?v=szmJPP0Wqr0 If you would like to use the

Continue reading

Check out latest Power BI showcase submission

Understanding your customer better. (Play with demo here) Review how sales have performed dynamically in any time frame and also compare that to similar time frames historically.  

Isolating The Top Or Bottom Outcomes Using RANKX In Power BI

Today we are going to focus on a technique used in the ‘Time Intelligence’ demo in the ‘Scenarios’ section of the Enterprise DNA showcase. I’ll show you how you can use RANKX in Power BI to get your top or bottom results. Being able to show dynamically the top or bottom outcomes of any calculations

Continue reading

Dynamically compare current totals to last years totals

Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the

Continue reading

Power BI Percent Of Total – Using CALCULATE Statement

Power BI percent of the total is a really common calculation that we require quite often. This is great to quickly show where the larger portion of results sits versus the entire population. Completing this in Power BI does not require much-written code, but it does require some understanding. It will generally be one of the

Continue reading