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
The Groupby function in DAX, Row context vs Filter Context
Seasonality and seasonal safety stock calculations in Power Pivot
Daunted by pivot tables? Don’t be – they’re easy once you understand the basics
Financial year total formulas for Power Pivot and Power BI. Custom time intelligence for data at differing granularities.
power pivot date table, calendar, financial year