Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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".
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...
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
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".
Perfect and Thank you so much for explaniation.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |