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 Community -
I have a set of data with part_numbers, quantities and dates. I am looking to be able to rank the dates from newest to oldest so that I can determine if the part is one that we are actively purchasing based on the most recent 3 weeks (sometimes the part is not purchased on the date and there is no line of data for the part for the specific date).
I have my RANKX formula ranking the dates
What I need to happen, when I change the range in the example above, I would need 2/1/2021 to have a RANK of 1 1/25/2021 to have a RANK of 2 and so on.
I am guessing this is a simple miss by me, but any help would be great.
Thanks
Ryan
Solved! Go to Solution.
I've set up a small example with a simple table that only has about 10 dates, then created this measure:
Ranking =
if( ISINSCOPE( Releases[Release Date] ),
RANKX(
ALLSELECTED( Releases[Release Date] ),
CALCULATE( SELECTEDVALUE( Releases[Release Date] ) ),,
DESC
)
)
and it works as expected, adjusting itself to the selected range.
I've set up a small example with a simple table that only has about 10 dates, then created this measure:
Ranking =
if( ISINSCOPE( Releases[Release Date] ),
RANKX(
ALLSELECTED( Releases[Release Date] ),
CALCULATE( SELECTEDVALUE( Releases[Release Date] ) ),,
DESC
)
)
and it works as expected, adjusting itself to the selected range.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |