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.
Dear All,
I have a price list from 4 suppliers.
I want to get the minimum unit price and respective supplier name and the second minimum unit price and respective supplier name as below.
Solved! Go to Solution.
hello !
you should create calculation column
in visual table you should in Filter Panel apply filter RanlColumn = 1 for get Lowest Price
in visual table you should in Filter Panel apply filter RanlColumn = 2 for get Second Price
if I answered at your question please mark topic as resolved 🙂
Unpivot the table in the power query, and then you can create rank for price.
You will have two columns, rename them as Supplier and price
Then create a rank like this
Rank = rankx(filter(Table, [supplier] =earlier([supplier]) && [Product Name] =earlier([Product Name]) ) , [Price],,asc,dense)
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
hello !
you should create calculation column
in visual table you should in Filter Panel apply filter RanlColumn = 1 for get Lowest Price
in visual table you should in Filter Panel apply filter RanlColumn = 2 for get Second Price
if I answered at your question please mark topic as resolved 🙂
how to avoid zero values columns while ranking?
Some results are wrong. Barcode 1889648 lowest must be 68, and second lowest 77.40
i corrected it, caz Data Type was text. Now its okey. Thank you.
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 |
---|---|
108 | |
105 | |
86 | |
74 | |
66 |
User | Count |
---|---|
123 | |
112 | |
96 | |
82 | |
72 |