Positive and Negative Rows Matching

[Anonymous]

Hi all,

I am trying to match previous rows with current rows.Does anyone has nay suggestion?

First I want need to find same Invoice amount and then postive invoice amount with negative invoice amount with same amounts and then in comments I need to put “Match” as a comments.   

Invoice Amount	Comments
500	Match
-500	Match
700
600	Match
-600	Match
400	Match
300
-400	Match

[Greg_Deckler]

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[Anonymous]

Hi Greg,

thank you so much for the link it is very interesting,In MTBF you have a options REPAIR START and REPAIR END.In my case i do not have one column and i need to compare rows. i am not sure,How implement MTBF in my scenario.Thanks

[Greg_Deckler · Accepted solution]

Right, it's not so much about MTBF as how to use EARLIER and FILTER to compare rows. You want to use EARLIER so just FILTER where ABS([Column]) = ABS(EARLIER([Column])) for example and if the COUNTX is more than 1, then it is a "Match".

[Anonymous]

Perfect and Thank you so much for explaniation.