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 Friends
This is Nagarjuna. I Have a small query, Can u please help me on this?
*Required Column | ||||
Item Code | Supplier Name | Supplier Price | Item Minimum Price | Minimum Price Supplier |
101 | A | 1 | 1 | A |
101 | B | 2 | 1 | A |
101 | C | 3 | 1 | A |
101 | D | 4 | 1 | A |
101 | E | 5 | 1 | A |
102 | F | 6 | 6 | F |
102 | G | 7 | 6 | F |
102 | H | 8 | 6 | F |
102 | I | 9 | 6 | F |
102 | J | 10 | 6 | F |
102 | K | 11 | 6 | F |
103 | L | 12 | 12 | L |
103 | M | 13 | 12 | L |
103 | N | 14 | 12 | L |
103 | O | 15 | 12 | L |
103 | P | 16 | 12 | L |
103 | Q | 17 | 12 | L |
103 | R | 18 | 12 | L |
104 | S | 19 | 19 | S |
104 | T | 20 | 19 | S |
104 | U | 21 | 19 | S |
104 | V | 22 | 19 | S |
104 | W | 23 | 19 | S |
How do i get the minimum price supplier name in a seperate column.
Thanks in advance
Warm regards
Nagarjuna
Solved! Go to Solution.
You can download the test file here: https://www.dropbox.com/s/gz881qnwd3dedfa/CheapestSupplier.pbix?dl=0
Have fun with DAX!
Alberto Ferrari
http://www.sqlbi.com
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |