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.
Trying to create a new column based on multiple sorted rows within the same OrderNumber.
I have the following schema:
Description | OrderNumber | OrderRow |
Art 1 | 30000 | 10 |
Art 2 | 30000 | 20 |
Art 3 | 30000 | 30 |
Art 4 | 30001 | 10 |
Art 5 | 30001 | 20 |
Art 6 | 30001 | 30 |
I want to make a new column with the Description of the rows with the lowest OrderRow value within the same OrderNumber.
Which would be:
Description | OrderNumber | OrderdRow | New Column |
Art 1 | 30000 | 10 | Art 1 |
Art 2 | 30000 | 20 | Art 1 |
Art 3 | 30000 | 30 | Art 1 |
Art 4 | 30001 | 10 | Art 4 |
Art 5 | 30001 | 20 | Art 4 |
Art 6 | 30001 | 30 | Art 4 |
I have no idea where to begin, probably due lack of DAX-syntax knowledge. Or maybe this is easier in the query editor.
Solved! Go to Solution.
Hi @MrMarshall,
You could create a calculated column with dax expression below.
New Column = CALCULATE ( MAX ( 'Order'[Description] ), FILTER ( 'Order', 'Order'[OrderNumber] = EARLIER ( 'Order'[OrderNumber] ) && 'Order'[OrderRow] = MIN ( 'Order'[OrderRow] ) ) )
Then you will get your expected output.
Hope this can help you!
Best Regards,
Cherry
Hi @MrMarshall,
You could create a calculated column with dax expression below.
New Column = CALCULATE ( MAX ( 'Order'[Description] ), FILTER ( 'Order', 'Order'[OrderNumber] = EARLIER ( 'Order'[OrderNumber] ) && 'Order'[OrderRow] = MIN ( 'Order'[OrderRow] ) ) )
Then you will get your expected output.
Hope this can help you!
Best Regards,
Cherry
Thank you! Worked perfectly 🙂
Hi @MrMarshall,
It is glad that we can help. Only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |