Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone!
I need to get the quantity sold related to the max and min price for each article code I have on my table. Also I'd like to filter the results by quarter. Can anyone help me? This is how my table looks like.
Thank you!
Rodrigo
Solved! Go to Solution.
Hi,
You may refer to my solution here.
Hope this helps.
Hi Victor,
I'm not sure what you mean. What I want is a measure that gives me the quantity associated with the max price for a product.
This is the scatter chart of a product's quantity sold and price for several months. What I want is to get the the quantity asociated with this maximum price. In this case 101 units for the price of $47 which is the max price for this product.
Thank you !
Hi,
It will be easier to help you if you show a simple table with your desired result. Also, share some data which can be pasted in MS Excel.
Hi!
What I would like to be able to see in a measure is something like this. My main goal is to have a measure that calculates price-elasticity for each product and quarter as I filter my report my product.
ProductCode | Max Price | Q(Max Price) | Min Price | Q(Min Price) | Quarter |
50973 | $ 45,99 | 103482,88 | $ 19,00 | 173120,65 |
I don´t know how to share the excel file over here, so here´s some of the data I have.
Cod.Art | Artículo | Venta Total | Precio | Cantidad | Mes-Año | Quarter |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.477.360,08 | $ 31,99 | 171221,05 | ene-16 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.256.697,01 | $ 31,99 | 164323,17 | feb-16 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.073.989,10 | $ 31,49 | 129374,10 | mar-16 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.591.942,26 | $ 31,49 | 145822,28 | abr-16 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.313.110,64 | $ 31,99 | 134826,88 | may-16 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.481.653,35 | $ 31,99 | 140095,49 | jun-16 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.521.434,19 | $ 31,99 | 141339,03 | jul-16 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 3.757.594,36 | $ 34,99 | 107390,56 | ago-16 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 3.565.921,35 | $ 33,99 | 104910,93 | sep-16 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.246.017,37 | $ 35,49 | 119639,86 | oct-16 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 3.766.518,78 | $ 35,49 | 106129,05 | nov-16 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.698.970,19 | $ 31,99 | 146888,76 | dic-16 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 3.289.292,35 | $ 19,00 | 173120,65 | ene-17 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.623.421,71 | $ 29,99 | 154165,49 | feb-17 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.708.464,62 | $ 36,99 | 154324,58 | mar-17 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.778.872,46 | $ 34,49 | 167552,16 | abr-17 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.040.787,82 | $ 25,99 | 193951,11 | may-17 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 6.242.214,97 | $ 30,99 | 201426,80 | jun-17 | Q2 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.061.936,40 | $ 29,99 | 168787,53 | jul-17 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.988.602,32 | $ 34,99 | 171151,87 | ago-17 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.084.544,09 | $ 34,99 | 145314,25 | sep-17 | Q3 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.503.864,58 | $ 34,99 | 157298,26 | oct-17 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 5.331.481,22 | $ 29,99 | 177775,35 | nov-17 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 8.667.901,71 | $ 37,99 | 228162,76 | dic-17 | Q4 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.885.697,44 | $ 40,99 | 119192,46 | ene-18 | Q1 |
50973 | POLLO TRES ARROYOS 1 KG | $ 4.759.176,25 | $ 45,99 | 103482,88 | feb-18 | Q1 |
Hi,
You may refer to my solution here.
Hope this helps.
You are welcone. If my reply helped, please mark it as Answer.
Hello - I am trying to build a price elasticity report in PowerBi. I used your post/ formulas which are great. However, the qty at min price formula doesn't sum all the rows that have the min price, it just returns one of the rows. How can I get it to sum all rows that have the minimum price? Thank yo
Hi,
Share some data and show the expected result.
Data Example | |||||||
Product | Invoice | Price/Gal | Qty | Year | Period | ||
Jet Fuel | 1090246 | 4.81 | 770 | 2019 | 5 | ||
Jet Fuel | 1090247 | 4.17 | 100 | 2019 | 5 | ||
Jet Fuel | 1090248 | 3.998 | 200 | 2019 | 5 | ||
Jet Fuel | 1090249 | 3.959 | 300 | 2019 | 5 | ||
Jet Fuel | 1090250 | 4.81 | 400 | 2019 | 5 | ||
Jet Fuel | 1090251 | 4.81 | 500 | 2019 | 5 | ||
Jet Fuel | 1090252 | 3.959 | 100 | 2019 | 5 | ||
Jet Fuel | 1090253 | 3.959 | 200 | 2019 | 5 | ||
Expected Results | |||||||
Max Price | 4.81 | ||||||
Min Price | 3.959 | ||||||
Qty Max Price | 1270 | ||||||
Qty Min Price | 600 | ||||||
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you! Thank you!
Hi,
If my reply helped, please mark it as Answer.
I don't see icon or way to mark is as Answer. Do I just write "Answer"?
If so, then your reply was the Answer.
I also put it in the tag.....
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |