Category Archives: Pivot Table

#Excel Super Links #134 – shared by David Hager

 

Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month

https://www.youtube.com/watch?v=U4iJyHr6tWI

New Functions – GENERATESERIES, SELECTEDVALUE

https://exceleratorbi.com.au/new-functions-generateseries-selectedvalue/

New Customers per Day – DAX Technique

https://powerpivotpro.com/2013/01/new-customers-per-day-technique-by-david-hager/

Dynamic Conditional Formatting

https://powerpivotpro.com/2012/11/david-hager-on-dynamic-conditional-formatting/

CREATING AN Nth OCCURRENCE DAX FORMULA

https://powerpivotpro.com/2011/03/guest-post-nth-occurrence-dax-formula/

 

#Excel Super Links #121 – shared by David Hager

 

Measure Dependencies in Power BI

https://exceleratorbi.com.au/measure-dependencies-power-bi/

Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable?

https://www.youtube.com/watch?v=r9A6Q3cDeKs

TetriCell

http://ambienteoffice.com.br/blog/tetricell/

Numerical Integration In Excel Using The Trapezoidal Rule

http://www.myengineeringworld.net/2013/06/integration-in-excel-trapezoidal-rule.html

#Excel Super Links 91-120: Great Collection of Excel and Power BI Links

https://dhexcel1.wordpress.com/2017/08/07/excel-super-links-91-120-great-collection-of-excel-and-power-bi-links/