Forum Discussion
RANKX between DATES
Anonymous , if you are creating the column refer 2nd one and if you are creating measure 1st one
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finaleThink expression should give you the calculated column you are looking for. I added a month column, but it would work with the data you posted if you just replace [Month] with [Date] in both places.
Rank Same Month = var currentmonth = PayTable[Month]var ranksamemonth = RANKX(FILTER(PayTable, PayTable[Month]=currentmonth), PayTable[Pay],,ASC)return ranksamemonthIf this works for you, please mark it as the solution. Kudos are appreciated too.Regards,Pat@Rich_coutinho , if you are creating the column, see the 2nd and if you are creating the 1st measure
For range, see these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
@Rich_coutinho , if you are creating the column, see the 2nd and if you are creating the 1st measure
For range, see these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale