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, he will put 1 and for others he will put 0.

 

tbl will looks like this:

 

CityVersion
City1TGF V1.0
City1TGF V6.0
City1TGF V3.0
City2TGF V1.0
City2TGF V1.0
City2 
City2 TGF V4.0
City3 TGF V2.0
City5 TGF V1.0
Need Help

5 Replies

  • 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)