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.
Guys,
I guess is a very simple question, the biggest problem is how to ask the question I guess. I have a table with articles and price; nevertheless the customer for whatever reason, have values that make no sense; this table for instance:
Item | Cost |
Cereal | 250 |
Cereal | 220 |
Cereal | 320 |
Cereal | 240 |
Cereal | 300 |
Cereal | 20 |
I have to get the lowest price (in this table 20), but in this case this one seems to be wrong. So I would like to stablish a theshold, for instance 20%. That means that if the cost value is less than average minus 20% this should be a mistake and I should take the lowest price over the threshold (in this instance 220 since the average minus 20% is 180). So I should not take into account the wrong value; how to do so?
Thanks a lot, regards,
Abelardo
Glad you are able to solve on your own and my notes helped you in attaining the result.
Appreciated for posting the solution for others.
Regards
something along these lines?
1. Sort the data by Item and cost i.e., Add an index column based on the item
2. Calculate the previous value
http://datacornering.com/calculate-last-or-previous-value-within-power-bi/
3. Calculate the thresold value and decide to display what you need to ...
If this is not the one you are looking, please ignore
Hey Sevenhills,
Thanks for your quick reply. Unfortunately, my description is not so good; nevertheless taking a look of what you sent me, some ideas came into my head, and got the solution.
This DAX give me what I am looking for, I added it for anyone that should find it helpful.
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |