Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Adding calculated columns to matrix visual

I'm trying to figure out how to add calculated columns to a matrix visual. I have a data set in excess of 10M records. Via a series of slicers the data set gets reduced to records of interest. Those ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

What would the three calculated columns be?  Though, since the original table is being filtered down you would probably want these to be measures. But one step at a time, if you could list out what the 3 calculations are that would be extremely helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I was seeking to keep it as simple as possible. I figure any simple algebraic example would be sufficient to get me. In reality I'll be using  a complex equation that apporoximates a curve from a government graph. The formula uses the the calculated National Estimate divided by1000 and then an exponent and natural log type equiation. From that I have two more simple algebra calculations to make and report.  The ultimate goal is to calculate what is now a manual lookup from a published graph.

     

    Thanks for you question. If you can Help, I'd be super greatful!

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous 

      You could create measures and add them in the Value field.

      For exponent and natural log type equiation, you could use EXP and LOG function.

      Learn syntax here : EXP function, LOG function

      Note that you might receive an error if the value is too large or too small.

      Measure_divide = SUM(Sheet2[National Estimate])/1000

Measure_exp = EXP([Measure_divide]/1000)

Measure_log = LOG([Measure_divide])

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Unfortunately the "National Estimate" numbers aren't sitting conveniently in a table as in the example. In my actual data, the "National Estimate" is a calcuated column of a in a Matrix visual. The visual gets calculated as a function of multiple slicers. I'm seeking to do additional columns based upon the results shown in the matrix visual.