Skip to content
  • Follow me on Twitter
  • About
  • Contact
  • Home

Power To The Masses

Power BI, Power Query, Power Pivot

Author: André de Lange

André de Lange has been using Power Pivot, Power Query and Power BI in a manufacturing business environment on an almost daily basis since the beginning of 2015. He has been harnessing the capabilities of Power Pivot extensively for business reporting, variance analysis, forecasting and financial analysis, and is eager to share his insights with others who have encountered similar business problems and who would like to know how to solve them in the Microsoft Power suite environment. André also hosts the official Hobart Power BI User Group, where people can get together and discuss all things related to Power Pivot/Power BI.
Written by André de LangeJuly 19, 2018October 10, 2018

Evaluation context in DAX and using the Groupby function when SUMX alone won’t do

The Groupby function in DAX, Row context vs Filter Context

Written by André de LangeNovember 2, 2017November 14, 2017

Seasonal safety stock in Power Pivot

Seasonality and seasonal safety stock calculations in Power Pivot

Written by André de LangeOctober 25, 2017October 25, 2017

Pivot tables 101: How to construct a pivot table and how NOT to construct one.

Daunted by pivot tables? Don’t be – they’re easy once you understand the basics

Written by André de LangeAugust 17, 2017August 4, 2018

Custom Time Intelligence formulas in DAX: Financial Year June to July

Financial year total formulas for Power Pivot and Power BI. Custom time intelligence for data at differing granularities.

Written by André de LangeMarch 30, 2017August 4, 2018

Create a Date Table with Power Pivot

power pivot date table, calendar, financial year

Create a website or blog at WordPress.com