note

[Excel Video Tutorial] How to display text strings as PivotTable values

In this video, I will explain how to display PivotTable values that combine text strings, such as 'Names'. Learn Excel Power Query and Power Pivot through video Using Excel PivotTables allows you to ...
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 ...