Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone!
I have a transactional table that contains the order ID within 2 columns:
Article | Order1 | Key | Order2 | Quantity |
AAAA | 100 | L1 | 2001 | 50 |
AAAA | 101 | L1 | 2200 | 70 |
AAAA | 105 | L2 | 100 | 100 |
AAAA | 106 | L2 | 101 | 100 |
The L1 key defines the last tracked quantity.
The L2 key defines the first tracked quantity.
Now I need to compare these two numbers to get the yield per order level.
But how?
In the example above for order 100, I would compare L1 = 50 with L2 = 100.
How would you build this relationship between a DAX measure?
Hello @joshua1990 ,
How do you mean to compare? What is the logic behing grouping? Is it just:
SUM of Order Qty of L1 / Sum of Order Qty of L2?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |