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