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 all,
Hope you all are fine!
I was wondering if it's maybe possible to create such a matrix as shown below in Power Bi. The system should select the correct percentage based on the price and the quantity. In excel I get this result when combining the index and match function.
@ManuelGeiger , seem like cohort
Create a bucket on Qty and price and use that on matrix row and column
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI
Hey @amitchandak , that will for sure work for a visualization purpose but I guess I can't calculate with that right?
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |