note

[Excel Power Pivot/DAX Video Tutorial] Calculating Monthly Total Sales and Month-over-Month ...

In this video, I will explain how to simultaneously calculate monthly total sales and the month-over-month growth rate in a PivotTable using an Excel workbook containing monthly sales data. Learn ...
note

[Excel Power Pivot/DAX Video Tutorial] Aggregating items below a threshold amount as 'Other'

In this video, I will explain how to use a DAX measure formula to aggregate products with total sales below a threshold amount selected by a slicer into an 'Other' category. Learn Excel Power Query ...