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 pu...
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