Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Trying to link two tables together from D365 BC to create a report for posted invoices with sales $ amount. Here are the two tables:
1. PostedSalesCreditMemos
2. PostedSalesInvoice_Line
In 'postedSalesCreditMemos' [Amount_Including_VAT] table there are few credits that need to be subtracted from postedSalesInvoice_Line[Amount_Including_VAT] table.
I am able to subtract the two columns from two tables with this measuring formula:
@sregimand , Column in M-M would be a challenge.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak wrote:@sregimand , Column in M-M would be a challenge.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak wrote:@sregimand , Column in M-M would be a challenge.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Total Sales is correct, however when I try to subtract credit applied to an invoice the Total Measures becomes as negative.
I have tried many ways of assoicating the two tables as many-to-one or one-to-many with no success.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |