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
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.
Seasonal safety stock in Power Pivot
Seasonality and seasonal safety stock calculations in Power Pivot
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
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.
Create a Date Table with Power Pivot
power pivot date table, calendar, financial year
