Forum Discussion

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
5 years ago
Solved

Flag max per category

I currently have a column which flags the latest week number in the table using the formula below.  Max WeekNumber flag = IF(TABLENAME[WeekNumber] = MAXA(TABLENAME[WeekNumber]),1,0) If the ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    bo_afk , Try a new column like

     


    Max WeekNumber flag = IF(TABLENAME[WeekNumber] = MAXX(filter(TABLENAME,[Year] = earlier([year])),[WeekNumber]),1,0)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

bo_afk , Try a new column like

 


Max WeekNumber flag = IF(TABLENAME[WeekNumber] = MAXX(filter(TABLENAME,[Year] = earlier([year])),[WeekNumber]),1,0)