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
June 30, 2019
Look up values within a date range

Want to look up values that correspond to certain date ranges and match them to dates? Read on.

Read More
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

Power to the Masses

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