Forum Discussion
Subtraction between two tables
Hello all,
Need help on the below please.
I have two tables Orders Received and Orders Entered.
Created two separate visuals that present those data by WeekEnding.
For each table data has been pulled with different filters from SQL Server.
I need to calculate the difference between Orders Received and Orders Entered and display by Weekending so it becomes a Backlog.
I have tried multiple ways of doing that, in vain.
Anonymous , For that you need to common date, and other dimension tables like item , customer etc.
Join these two with common dimension/master table and then you can create a measure
new measure =
[order received] - [order entred] // both are meaures
TRy to be in star schema
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
3 Replies
Anonymous , For that you need to common date, and other dimension tables like item , customer etc.
Join these two with common dimension/master table and then you can create a measure
new measure =
[order received] - [order entred] // both are meaures
TRy to be in star schema
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
how about if my two table are many to many relationship, is there any other way to handle this pls ? i would like to display the remain balance after deduction by product type in a matrix table. all the data are from the fact table. thanks in advance
How to Subtract 2 different columns of calculated amounts from 2 different tables? Can anyone help please.
I have my seperate Calendar table, 2 tables as "Expenses" and "Leadboard" both tables have date columns with different names. I want both tables total amount subtracted value only.
