A really common calculation that we require quite often is to calculate the % of a total amount. This is great to quickly show where the larger portion of results sit 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
Users of Power BI will quickly find one drawback to making compelling reports and dashboards, and it all has to do with colours! Unfortunately, the team at Microsoft have not quite yet worked out how to include themes into Power BI desktop and the online service. No doubt they will look to remedy this as
Every consumer goods company needs this If you sell a product, good or service, you will no doubt want to be able to draw up some analysis on how you are going. What products are selling to which customers in what locations? Which warehouses or factories are producing them? How are we performing over time?
Breaking down the way DAX works The DAX engine is a complex beast. How it stores the data, then works through it to calculate answers is quite spectacular. Let’s step back for a moment though and try to distill it down into some simple steps, that we can memorise and intuitively start iterating over when
Effort here will pay dividends later Placing effort into formatting your DAX code will make a huge difference as you build out your data models in Power BI. DAX, at times is a confusing language as it is, so as soon as you get into the slightly complex territory unformatted DAX code becomes almost impossible to