Forum Discussion
Abevann
Helper III
Helper IIIFilter the lowest value over a threshold
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 value...
sevenhills
Super User
Super Usersomething 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
AbevannHelper III
Helper IIIHey 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.
Minimum price = CALCULATE(MIN(INV1[Price]),
FILTER(INV1, INV1[Price] > (AVERAGE(INV1[Price]) * 0.80))
)
Thanks, regards,
Abelardo