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
ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Zakaria_1980 

maybe you can try to create two columns.

Column = 
var v=right('Table'[Version],3)
return if(v="",0,int(v))

Column 2 = 
VAR _max=CALCULATE(max('Table'[Column]),ALLEXCEPT('Table','Table'[City]))
return if('Table'[Column]=_max,1,0)

  • 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