Microsoft Power BI

Getting more from your data

Welcome to Power to the Masses

where you can read about interesting ways to leverage the capabilities of Microsoft Power Pivot, Power Query and Power BI to develop valuable business insights.

Recent Articles

Check out our latest articles here
July 19, 2018
DAX GroupBy and Evaluation Context in DAX

I recently came across an interesting use case for the Groupby function in DAX, and while doing so, thought it would also make a great example for explaining evaluation context in DAX. Consider the following table of data showing purchase requirements for two products, from multiple suppliers. Each product/SKU combination can only be bought in […]

Read More
November 2, 2017
Seasonal Safety Stock

Seasonality is an important phenomenon to consider for many businesses, and in the context of this post refers not only to seasons in terms of Winter, Summer, and so on, but will also consider how you can report on business activity in terms of custom-defined seasons. To state the obvious, an ice cream shop might […]

Read More
October 25, 2017
Pivot Tables 101: How to construct a pivot table and how not to Construct one

Many people who do not regard themselves as Excel gurus find themselves in situations where they would like to be able to represent tabular data somehow to allow them the functionality of filtering, cross-tabulation (pivoting) and hierarchical sorting that pivot tables offer. The Excel wizard for creating pivot tables could certainly have been more instructive, […]

Read More

Power to the Masses

Copyright 2019 Power to the Masses.
cloud-checkenvelopefile-add linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram