Log In
Register
Home
June 24, 2020
Offline
Hello friends, Hope all is well! please help me create a DAX formula.
As you can see in the below image, I need the formula to place an X mark if there are matching fields at the
last column on the rows that have the same:
A. Invoice Number.
B. Branch Name.
C. The amount matches but one in positive and the other is negative.
Thank you in advance for your time & efforts.
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
If I understand correctly, you could use this:
=IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EARLIER([Branch])&&[Amount]=-EArlier([Amount])))>0,"X",blank())
Answers Post
June 24, 2020
Offline
Dear Velouria, that was awesome, may I please ask for one more modification?
if amount results are ZERO no X. the formula should only work on netting out figures, e.g. 150 VS -150 etc
Thank you so much
Trusted Members
Moderators
November 1, 2018
Offline
You should be able to just wrap another IF:
=IF([Amount]<>0,IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EARLIER([Branch])&&[Amount]=-EArlier([Amount])))>0,"X",blank()),BLANK())
1 Guest(s)
