Forum Discussion

bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
9 months ago
Solved

Variance column for Dynamically selected columns

Greetings,   I have a matix that consist of dynamic columns. The data consist of reports that are Jan-Dec.  Each month has it's own Jan thru Dec totals in each file, see below left side.  Currently...
Need Help
  • bjackson2760's avatar
    bjackson2760
    9 months ago

    Thanks everyone.  I found it on another thread.  I found this code and used it, but it only worked once I have a sum total next to it.

    var mmax = CALCULATE(max(DataProfile[Units]),allselected(Contacts[Name]))
var mmin = CALCULATE(min(DataProfile[Units]),allselected(Contacts[Name]))
return mmax-mmin

    I will come return to give credit.  Thanks. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 months ago

Hi,

So if you have selected 3 months (as shown in the picture), then how should variance be calculated?

  • bjackson2760's avatar
    bjackson2760
    Icon for Helper I rankHelper I
    9 months ago

    I am suggesting to my client that they only compare 2 at a time or do a visual.  Two is difficult enough,also it would make any sense to try to get a variance from 3 or more.  

     

    Thank you, I have posed that very question to him, I am awaiting feedback. 🙂

  • bjackson2760's avatar
    bjackson2760
    Icon for Helper I rankHelper I
    9 months ago

    Thanks Ashish.  I need a variance for 2 selected months.  I'll just let him know that is the limit and makes sense.