Statistical Function for calculating the Range R

[Anonymous]

Hi,

I have the table below.

I am looking for the statistical Range R.

For the rows, it is simple: Maximum - Minimum.

But how do I calculate the Range R for the total table?

The outcome of this formula must be 18 (highest vaue in the table) - 9 (lowest value in the table) = 9

Thanks!

John

week	day_1	day_2	day_3	day_4	day_5	Count	Addition	Average	Minimum	Maximum
1	10	9	11	10	10	5	50	10	9	11
2	10	18	16	11	10	5	65	13	10	18
3	10	10	9	10	11	5	50	10	9	11

[ribisht17 · Accepted solution]

@Anonymous 

Step 1: 

Max = MAXX( { MAX(MaxMinTableAcross[day_1]),MAX(MaxMinTableAcross[day_2]),MAX(MaxMinTableAcross[day_3]),MAX(MaxMinTableAcross[day_4]),MAX(MaxMinTableAcross[day_5])},[Value])

Step 2: 

Min = MINX( { Min(MaxMinTableAcross[day_1]),Min(MaxMinTableAcross[day_2]),Min(MaxMinTableAcross[day_3]),Min(MaxMinTableAcross[day_4]),Min(MaxMinTableAcross[day_5])},[Value])

Step 3:

Solution = MaxMinTableAcross[Max]-MaxMinTableAcross[Min]

Note: Keep [Value] as it is in your calculation there

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Anonymous]

hi @ribisht17 ,

Thanks, all clear!

JOhn