Power bi questions

Hello all, I really could use your help . i have this project that i have to deliver on saturday and i have some questions left on the app, please note that i am new to it. Firstly, there was "Categ.codecateg" is this join or combine or concatenate ? knowingly that those columns are numbers and we will be getting their sum afterwards, how to do we combine if we need to sum ? secondly, how can sum be not in the whole column ? just a cell. we need to choose a column to make new measure a specific entry vault/cell for the summarized numbers. SUM(InvT_GeneralTransactions_1.Qty + InvT_GeneralTransactions_1.Bonus) * - 1 AS Qty, SUM(InvT_GeneralTransactions_1.Sell - InvT_GeneralTransactions_1.VouDiscount) * - 1 AS NetSellVal, SUM(InvT_GeneralTransactions_1.Cost) *-1 as TotCost thirdly, how do we make inner join if the question was fourthly , what does this mean ? FROM dbo.InvT_GeneralTransactions(1,0,99999,'0', 'zzzzzzzzzzzzzzzzz', '2022-01-01', '2022-01-31', 4, 'sys') AS InvT_GeneralTransactions_1) how is it done ? dbo isn't a given column, others are INNER JOIN InvItemsMF ON InvT_GeneralTransactions_1.CompNo = InvItemsMF.CompNo AND InvT_GeneralTransactions_1.ItemNo = InvItemsMF.ItemNo INNER JOIN InvCategCodes ON InvItemsMF.CompNo = InvCategCodes.CompNo AND InvItemsMF.Categ = InvCategCodes.Categ inner join InvStoresMF on InvT_GeneralTransactions_1.CompNo =InvStoresMF.CompNo and InvT_GeneralTransactions_1.StoreNo = InvStoresMF.StoreNo WHERE (InvT_GeneralTransactions_1.CompNo = 1) AND (InvT_GeneralTransactions_1.VouType IN (2, 9)) GROUP BY InvItemsMF.Itemno, ItemDesc ,InvCategCodes.Categ, InvCategCodes.CategName,InvT_GeneralTransactions_1.StoreNo,InvStoresMF.StoreName i would really appreciate if everyone who can, helps asap, please. Wiz #powerbi #join power.bi