Forum Discussion
Show when two float/ double numbers are the same in two seperate tables
I have two tables:
Cash Receipts (Amount, Customer, other columns)
Accounts Receivable Aging (Balance Due, Customer, other columns)
I would like to show when the Cash Receipt amount for a given customer is the same as the Balance Due amount for that same customers. There could be numerous Cash Recepts and numerous Balance Due amounts... My hope is to make life easier on the billing team in some way to allow power bi to do this work for them.
Here is an example.
Anonymous Maybe:
Column = VAR __Amount = [Transaction Amount] VAR __Customer = [Customer Name] VAR __Invoice = MAXX(FILTER('AR',[Customer Name] = __Customer && [Balance Due]=__Amount),[Invoice Number]) RETURN __Invoice
2 Replies
- Greg_Deckler
Community Champion
Anonymous Maybe:
Column = VAR __Amount = [Transaction Amount] VAR __Customer = [Customer Name] VAR __Invoice = MAXX(FILTER('AR',[Customer Name] = __Customer && [Balance Due]=__Amount),[Invoice Number]) RETURN __Invoice