Adding Calculated Colum to Matrix Visual

[atowriss74]

Hi,

I have the below Matrix, which has Channel Names as Rows.  I want to add a column at the end that Calculates % Variance of the CYD and PYTD ONLY columns, by Channel.  Is this possible?  I have Tabular Editor installed, if that could be used as an option.  

I have a measure created, and could put that in another Matrix, but they won't be linked, so sorting would be an issue.

Is what I want to do even possible?

[Greg_Deckler]

@atowriss74 It is possible, but not pretty. The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[atowriss1]

@Greg_Deckler ....wow.  That seems a bit above my current knowledge, but I will study it.  Thanks so much

[Greg_Deckler]

@atowriss1 Well, you can always go the other route of just adding the column to Values, turning off word wrap for headers and values and then shrinking up all the extraneous columns it creates in your visual...

[atowriss1 · Accepted solution]

@Greg_Deckler , that is going to be my temporary solution for now!