I Need to add these two coloumns but i am unable to add them Cost per sale and net revenue per piece

[faiqsadiq1]

[AnkitKukreja]

Hi! @faiqsadiq1 

Use the below m-code or dax and it should work for you.

Addition = ( 'Table'[Sales per piece] + 'Table'[Net Revenue] )

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bY7BEYAwCAR7yVuZC+ABtTjpvw0zal76Zed2Oc+2h0A9CsECFNq2VqLRxjbhISTqYHWGMvyGqAdS0rKrZYKWVjfsupblDiNdLdA5YQpfrf81613GX1NtaT/NnKel/TTnt2hjXA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Sales per piece" = _t, #"Net Revenue" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Sales per piece", type number}, {"Net Revenue", type number}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each ( ( [Sales per piece] ) + [Net Revenue] ))
in
#"Added Custom"

If this doesn't work. Can you please copy-paste the data or share the sample data to have a look at your issue, I am unable to access your file.

[faiqsadiq1]

Hey Ankit,
Thankyou for the solution.

I tried it but i was unable to find this way but then i tried group by and it worked.
Thankyou for the utmost support.