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.
Hello - hoping someone is able to help me out with this, I'm a little out of my depth. I think either a column or DAX would work for me.
Ultimately I want to rank a vendor's weekly pricing lowest to highest based on part number. Since we can get pricing at different times during the week I created a Year-Week column to base this off of. I added a rank column below of how I would like it to work. I highlighted the columns in blue that I believe are necessary to accomplish this, the rest are just for context.
Thanks in advance!
Solved! Go to Solution.
Hello @hixkim
Create a new calculated column with the following formula:
Sorting Column =
RANKX (
FILTER ( 'Table', 'Table'[Year-Week] = EARLIER ( 'Table'[Year-Week] ) && 'Table'[Item Number] = EARLIER ( 'Table'[Item Number] ) ),
'Table'[Unit Cost],
,
ASC,
DENSE
)
Workspace Attached
Hello @hixkim
Create a new calculated column with the following formula:
Sorting Column =
RANKX (
FILTER ( 'Table', 'Table'[Year-Week] = EARLIER ( 'Table'[Year-Week] ) && 'Table'[Item Number] = EARLIER ( 'Table'[Item Number] ) ),
'Table'[Unit Cost],
,
ASC,
DENSE
)
Workspace Attached
You're amazing. Thank you!!
Hey @hixkim ,
there is a great article about that from SQLBI. Check it out, I think it will solve your issue:
RANKX on multiple columns with DAX and Power BI - SQLBI
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |