New calculated Column in Matrix based on output

[Anonymous]

Hi Experts

I have a matrix table, in that based on my output column I need to sum from two columns. could you please help me how to do that.

there are three columns selected. Let me know if need any further details

In the same matrix table, I need a new column which is CF - FL = Output.

Category	Actuals	Plan	CF	FL	CF - FL
CA	79977	13481	176283	899932
CD	49817	13683	125146	553024
CDT	56014	13483	123338	595184
CDPL	52788	855834	127691	596230
CM	18833	508201	127691	33
ROW	Category
Column	Ver
Values	Revenue

[ShaWo]

If you are talking about the matrix visualisation, then I think you'd need a new measure rather than new calculated column. Which would be something like:

CF - FL :=
var cf = calculate(sum(revenue);ver="CF")
var fl = calculate(sum(revenue);ver="FL")

return cf-fl

If you are talking about power query side of things, then you'd need to make new column in PowerQuery -> Add column -> select CF -> From number -> standad -> substract -> choose FL.