Need to add two existing calculated columns to the end of my matrix. Please help

[iGWizard]

Hi,

I would like to add two columns to the end of my matrix. my matrix currently looks like this.

I have both Total Difference and 'Note Type' created as calculated columns. 

When I pull in these two calculated columns to sit under 'Month' in the columns well. they do not appear.

How can I go about doing this?

Thanks

[iGWizard]

The whole point of my project is to transition the current process from Excel to Power BI. I'll just use two separate tables to solve my issue. Thanks

[Anonymous]

Hi @iGWizard ,

Based on the information, drag the calculated columns into the Values of matrix.

If it still doesn't show the calculated column data, try to use power query Advanced editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUSpOzEktBtKmBgZKsToQsdzEovTMPCDDyEAVLphUmpKeWgJkGEJVGiHpNkESg+s2huo2QtZtbgoWMzFA0g000QAhCtdvaKqKEIUbYGmpFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Division = _t, Specs = _t, Values = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Division", Int64.Type}, {"Specs", type text}, {"Values", type number}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Division", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Division", type text}}, "en-US")[Division]), "Division", "Values"),
    #"Added Custom" = Table.AddColumn(#"Pivoted Column", " Total Difference", each [column1]+[column2]),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "NoteType", each [column3]/3)
in
    #"Added Custom1"

You can view the following links to learn more information.

Solved: Can you add calculated columns to end of matrix? - Microsoft Fabric Community

Solved: Need to add extra column in existing Power BI matr... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

 If you want to add columns to a table, use a table visual, not a matrix visual.

[iGWizard]

Because my months column are unpivoted in the PQ file processing steps (as I've set it up for columns to be dynamic when new data is uploaded each month), a matrix is the only way to display the data in the structure I need, with months across the top

[lbendlin]

That's a typical antipattern. If you need that exact layout then use Excel. In Power BI you use separate visuals.