Forum Discussion
Syndicate_Admin
Administrator
AdministratorTotal Sum on all lines
Well, I'm having trouble doing the following. I have a table whose rows are types of vouchers, and which has 2 columns, one cost and one sales. . What I need is that the sale amount per ...
bhelou
Responsive Resident
Responsive ResidentDear ,
Just create a new column either in power queries or in Data view in poiwer bi Desktop :
Total = column [ sales ] - column [ cost ]
////
kidnly see if that is the solution , or if not share some samples ( images ) or sample of the file .
* kindly accept as a solution and a kudo would be gretfull .
Regards ,
Syndicate_AdminAdministrator
AdministratorAs this is a database direct data model I cannot access power query to create a new column. Is there any alternative created measures or some trick without accessing the power query?