Forum Discussion
Calculating Net Sales from 2 Different Columns
Hello - I am trying to calculate net sales: Total invoiced amount - amount returned Table 1: contains column "total amount" Table 2: contains column "amount returned" They are related via ...
can you tell me what you have done already and what the issues are?
if your tables are joined essentially you should be able to create the measures, if you can share some data data or screenshot the relationships that would be useful and a copy of the measures that aren't working.
if your tables are joined essentially you should be able to create the measures, if you can share some data data or screenshot the relationships that would be useful and a copy of the measures that aren't working.
vanessafvg thanks for the reply. The issue is that net sales for customer or manufacturer are not displaying correctly - which makes me think it's an issue with relationships.
I tried adding measures and calculated columns (using the formula screenshotted below) on both "PostedSalesInvoiceSalesInvLines" and "PostedSalesInvoices". The total amount comes from "PostedSalesInvoiceSalesInvLines" and the amount returned comes from "PostedSalesCreditMemosLines".
Hi,
Share the link from where i can download your PBI file. To void confusion, please remove the tables which are not required. Also, please show the expected result very clearly.
