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.
How to get First, Second, Third Max Prices from another Table?
Solved! Go to Solution.
I believe RANKX() would be suitable here!
I believe RANKX() would be suitable here!
I have data similar to table A for Product & Prices (each product have 4 or 5 Prices) like
Product Price
Tea 25
Tea 30
Sugar 15
Sugar 55
Tea 20
and
table B for Product and other data
Tea XYZ
Sugar XYZ
Now what I want is something like below and I have researched a lot and couldn't find a proper solution to that.
Product Price 1 Price 2 Price 3
Tea 30 25 20
Sugar 55 15 -
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 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |