Forum Discussion

JackWren's avatar
JackWren
Icon for Helper II rankHelper II
4 years ago
Solved

Create ranking based on specific value (current month)

Hi,    I have a dax calendar with the following elements :    Dax Calendar = ADDCOLUMNS ( CALENDAR (DATE(YEAR(TODAY())-1,1,1), DATE(YEAR(TODAY()),12,31)), "YEAR", YEAR ( [Date] ), "YearMont...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    add a new column to your calendar definition

    "Ranking", 
    var yearMonInt = INT( FORMAT( [Date], "YYYYMM"))
    var todayInt = INT( FORMAT( TODAY(), "YYYYMM"))
    return yearMonInt - todayInt
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

add a new column to your calendar definition

"Ranking", 
var yearMonInt = INT( FORMAT( [Date], "YYYYMM"))
var todayInt = INT( FORMAT( TODAY(), "YYYYMM"))
return yearMonInt - todayInt
JackWren's avatar
JackWren
Icon for Helper II rankHelper II
4 years ago

Thank you so much! It definitely does the job 🙂