Excel Customers Paying Less Than Average - Episode 2639 

An absolutely great video, always wondered how the heck can calculate the value fields of a pivot table within the pivot table but never thought of going this route. Thank you so much

Rad DAX!!! I am like you, I love to right-click table name, Add Measure!!

Thanks Mr Excel.

Nice one

Great video, but it could have all been done in one calculation in the DAX editor using variables.

Nice video Mr Excel!

Hello Bill :) How are you? I have a question, it is entirely possible to do this in less measures, not to mention its easier in the manage view from power pivot, So you did it this way to show it step by step?

Great video!!✌ For fun, a formula: =LET(t,Sales,fl,0, f,LAMBDA(x,TAKE(TAKE(x,,-1)/TAKE(x,,-2),,1)), v,CHOOSECOLS(t,3,7), a,GROUPBY(INDEX(t,,4),v,SUM,,0), b,GROUPBY(CHOOSECOLS(t,4,1),v,SUM,,0), x,XMATCH(TAKE(b,,1),TAKE(a,,1)), j,INDEX(f(a),x), k,f(b)/j, h,HSTACK(b,j,k), IF(fl,FILTER(h,k

Quick question: How would you do this same thing, but not include the customer you ae on in the calculation? If one customer was grossly underpaying, it would bring the average down for everyone and make it look like the person was paying slightly less than average than they actually are.

Isn’t that what “show values as…” is for?