Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |