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