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 everyone, I was thinking on solving this but I got stuck to the last part.
So imagine you have this kind of table
Order Number | Order Number Line | Status | Date | Qty |
AAA | AA1 | Booked | 2/2/23 9:29 AM | 2 |
AAA | AA1 | Booked | 2/3/23 9:29 AM | 2 |
AAA | AA1 | Shipped | 2/4/23 9:29 AM | 3 |
AAA | AA1 | Shipped | 2/5/23 9:29 AM | 2 |
AAA | AA2 | Booked | 2/6/23 9:29 AM | 4 |
AAA | AA2 | Booked | 2/7/23 9:29 AM | 4 |
AAA | AA2 | Shipped | 2/8/23 9:29 AM | 2 |
AAA | AA2 | Shipped | 2/9/23 9:29 AM | 3 |
AAA | AA3 | Shipped | 2/10/23 9:29 AM | 1 |
AAA | AA3 | Shipped | 2/11/23 9:29 AM | 3 |
BBB | BB1 | Booked | 2/12/23 9:29 AM | 2 |
BBB | BB1 | Booked | 2/13/23 9:29 AM | 3 |
BBB | BB1 | Booked | 2/14/23 9:29 AM | 5 |
BBB | BB1 | Booked | 2/15/23 9:29 AM | 6 |
BBB | BB1 | Shipped | 2/16/23 9:29 AM | 6 |
BBB | BB2 | Booked | 2/17/23 9:29 AM | 3 |
BBB | BB2 | Booked | 2/18/23 9:29 AM | 4 |
BBB | BB2 | Shipped | 2/19/23 9:29 AM | 4 |
The goal is to have something like this
Basically I want to put that into a Matrix Table.
let me explain the Logic.
Solved! Go to Solution.
The score makes no sense as the quantity for AA2 is not the same (4 vs 2) so the top score should be 0.
See attached for the proposed implementation.
Thanks for this but I figure it out.
Its using INSCOPE formula,
IF INSCOPE of the ORDER NUMBER compute with the Total, and if its in ORDER ITEM LINE it will compute by Order Item Line.
Thanks!
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 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |