Forum Discussion
Solved
Comparing Values between 2 tables and displaying them using matching Date and ID's
I am retrieving data from two different sources, the point of this exercise is to check if the data retrieved from both places match. If not, a prompt is sent to the client about discrepancies in the...
you don't need to create relationships between two tables.
pls try this
measure = sumx(FILTER(all('Sheet1 (2)'),'Sheet1 (2)'[Customer ID]=max(Sheet1[Customer ID])&&'Sheet1 (2)'[Customer Name]=max('Sheet1'[Cus Name])),'Sheet1 (2)'[Quantity]) Measure 2 = [measure]-sum(Sheet1[Quantity])pls see the attahment below
