Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Create a new column from matrix with different variables

‎08-16-2023 08:11 PM

Hi

I have a data like below:

VariableServerWeekGroupValue
RevenueFLOR202305Control Pre2370313.086
RevenueFLOR202306Control Pre2756051.982
RevenueFLOR202307Control Pre2665521.669
RevenueFLOR202308Control Pre2437754.49
RevenueFLOR202309Control Pre2676226.286
RevenueFLOR202310Control Pre2693622.223
RevenueFLOR202311Control Pre2421782.247
RevenueFLOR202312Control Pre2629487.901
RevenueFLOR202313Control Pre2708551.867
RevenueFLOR202314Control Pre2738831.475
RevenueFLOR202315Control Pre2803467.566
RevenueFLOR202316Control Pre3061859.264
RevenueFLOR202317Control Pre2873843.913
RevenueFLOR202318Control Pre2739174.085
RevenueFLOR202319Control Pre3122420.831
RevenueFLOR202320Control Pre2877373.635
RevenueFLOR202321Control Post2640081.796
RevenueFLOR202322Control Post2444862.92
RevenueFLOR202323Control Post2776924.089
RevenueFLOR202324Control Post2454083.756
RevenueFLOR202325Control Post2365069.529
UnitsFLOR202305Control Pre                             952
UnitsFLOR202306Control Pre                          1,001
UnitsFLOR202307Control Pre                          1,009
UnitsFLOR202308Control Pre                             895
UnitsFLOR202309Control Pre                             953
UnitsFLOR202310Control Pre                             964
UnitsFLOR202311Control Pre                             875
UnitsFLOR202312Control Pre                             925
UnitsFLOR202313Control Pre                             925
UnitsFLOR202314Control Pre                             901
UnitsFLOR202315Control Pre                             984
UnitsFLOR202316Control Pre                          1,004
UnitsFLOR202317Control Pre                             972
UnitsFLOR202318Control Pre                             940
UnitsFLOR202319Control Pre                          1,000
UnitsFLOR202320Control Pre                             945
UnitsFLOR202321Control Post932
UnitsFLOR202322Control Post871
UnitsFLOR202323Control Post940
UnitsFLOR202324Control Post803
UnitsFLOR202325Control Post836
RevenueFLOR202305Test Pre141932.99
RevenueFLOR202306Test Pre155338.142
RevenueFLOR202307Test Pre153599.91
RevenueFLOR202308Test Pre183597.63
RevenueFLOR202309Test Pre168624.77
RevenueFLOR202310Test Pre203315.0498
RevenueFLOR202311Test Pre174652.981
RevenueFLOR202312Test Pre160667.563
RevenueFLOR202313Test Pre124144.426
RevenueFLOR202314Test Pre153912.892
RevenueFLOR202315Test Pre189685.0888
RevenueFLOR202316Test Pre166892.7587
RevenueFLOR202317Test Pre163015.732
RevenueFLOR202318Test Pre139986.05
RevenueFLOR202319Test Pre194589.9912
RevenueFLOR202320Test Pre119454.741
RevenueFLOR202321Test Post152635.5474
RevenueFLOR202322Test Post103231.5005
RevenueFLOR202323Test Post154941.7986
RevenueFLOR202324Test Post163418.1057
RevenueFLOR202325Test Post86746.99575
UnitsFLOR202305Test Pre87
UnitsFLOR202306Test Pre92
UnitsFLOR202307Test Pre78
UnitsFLOR202308Test Pre100
UnitsFLOR202309Test Pre77
UnitsFLOR202310Test Pre73
UnitsFLOR202311Test Pre68
UnitsFLOR202312Test Pre88
UnitsFLOR202313Test Pre63
UnitsFLOR202314Test Pre77
UnitsFLOR202315Test Pre82
UnitsFLOR202316Test Pre82
UnitsFLOR202317Test Pre88
UnitsFLOR202318Test Pre86
UnitsFLOR202319Test Pre84
UnitsFLOR202320Test Pre67
UnitsFLOR202321Test Post84
UnitsFLOR202322Test Post66
UnitsFLOR202323Test Post97
UnitsFLOR202324Test Post99
UnitsFLOR202325Test Post46
RevenueFLOR202205Control Pre46787.626
RevenueFLOR202206Control Pre46784.3794
RevenueFLOR202207Control Pre44241.4672
RevenueFLOR202208Control Pre44317.17895
RevenueFLOR202209Control Pre44259.28195
RevenueFLOR202210Control Pre45889.5
RevenueFLOR202211Control Pre42594.6358
RevenueFLOR202212Control Pre50997.6991
RevenueFLOR202213Control Pre49062.7
RevenueFLOR202214Control Pre51166.26235
RevenueFLOR202215Control Pre47667.8
RevenueFLOR202216Control Pre47713.672
RevenueFLOR202217Control Pre44777.2227
RevenueFLOR202218Control Pre45486.15
RevenueFLOR202219Control Pre43921.252
RevenueFLOR202220Control Pre46273.326
RevenueFLOR202221Control Post36724.9981
RevenueFLOR202222Control Post35074.95
RevenueFLOR202223Control Post50669.1
RevenueFLOR202224Control Post40447.55
RevenueFLOR202225Control Post38053.51853
UnitsFLOR202205Control Pre127
UnitsFLOR202206Control Pre127
UnitsFLOR202207Control Pre122
UnitsFLOR202208Control Pre123
UnitsFLOR202209Control Pre124
UnitsFLOR202210Control Pre120
UnitsFLOR202211Control Pre114
UnitsFLOR202212Control Pre137
UnitsFLOR202213Control Pre132
UnitsFLOR202214Control Pre142
UnitsFLOR202215Control Pre132
UnitsFLOR202216Control Pre129
UnitsFLOR202217Control Pre123
UnitsFLOR202218Control Pre127
UnitsFLOR202219Control Pre120
UnitsFLOR202220Control Pre126
UnitsFLOR202221Control Post95
UnitsFLOR202222Control Post91
UnitsFLOR202223Control Post127
UnitsFLOR202224Control Post103
UnitsFLOR202225Control Post100
RevenueFLOR202205Test Pre141932.99
RevenueFLOR202206Test Pre155338.142
RevenueFLOR202207Test Pre153599.91
RevenueFLOR202208Test Pre183597.63
RevenueFLOR202209Test Pre168624.77
RevenueFLOR202210Test Pre203315.0498
RevenueFLOR202211Test Pre174652.981
RevenueFLOR202212Test Pre160667.563
RevenueFLOR202213Test Pre124144.426
RevenueFLOR202214Test Pre153912.892
RevenueFLOR202215Test Pre189685.0888
RevenueFLOR202216Test Pre166892.7587
RevenueFLOR202217Test Pre163015.732
RevenueFLOR202218Test Pre139986.05
RevenueFLOR202219Test Pre194589.9912
RevenueFLOR202220Test Pre119454.741
RevenueFLOR202221Test Post152635.5474
RevenueFLOR202222Test Post103231.5005
RevenueFLOR202223Test Post154941.7986
RevenueFLOR202224Test Post163418.1057
RevenueFLOR202225Test Post86746.99575
UnitsFLOR202205Test Pre87
UnitsFLOR202206Test Pre92
UnitsFLOR202207Test Pre78
UnitsFLOR202208Test Pre100
UnitsFLOR202209Test Pre77
UnitsFLOR202210Test Pre73
UnitsFLOR202211Test Pre68
UnitsFLOR202212Test Pre88
UnitsFLOR202213Test Pre63
UnitsFLOR202214Test Pre77
UnitsFLOR202215Test Pre82
UnitsFLOR202216Test Pre82
UnitsFLOR202217Test Pre88
UnitsFLOR202218Test Pre86
UnitsFLOR202219Test Pre84
UnitsFLOR202220Test Pre67
UnitsFLOR202221Test Post84
UnitsFLOR202222Test Post66
UnitsFLOR202223Test Post97
UnitsFLOR202224Test Post99
UnitsFLOR202225Test Post46

 

I have created a matrix with average of values of groups whch looks like this:

niharikatomar_0-1692241644389.png

Now I want to add a column within the same table or matrix with name "Lift" Since the tables looks like the above, how can I refer different variables of the group column in the formula.The formula should be:

([Test Post]-([Test Pre]+Number.Abs([Test Pre])*([Control Post]-[Control Pre])/Number.Abs([Control Pre])))/Number.Abs([Test Pre]+Number.Abs([Test Pre])*([Control Post]-[Control Pre])/Number.Abs([Control Pre]))

 

Thanks

Labels:
Message 1 of 1
103 Views
0
0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All