Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago
Solved

need support

Dears,   i've a table with multiple Cities which are not sorted and next to each city some versions . i would like to add another column where whenever the version is the highest one in that city, ...
Need Help
Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago

This is what i'm getting as error, could you help me please

 

 

 

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Zakaria_1980 

maybe try 

Column 2 = 
VAR _max=CALCULATE(max(sheet1(var v]),ALLEXCEPT('sheet1','sheet1'[project name]))
return if('sheet1'[var v]=_max,1,0)
  • Zakaria_1980's avatar
    Zakaria_1980
    Post Patron
    5 years ago

    i tried it but it doesn't work. could you apply it in your laptop and share with me the correct dormula to put please.

    thanks in advance