need support

[Zakaria_1980]

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:

City	Version
City1	TGF V1.0
City1	TGF V6.0
City1	TGF V3.0
City2	TGF V1.0
City2	TGF V1.0
City2
City2	TGF V4.0
City3	TGF V2.0
City5	TGF V1.0

[ryan_mayu]

@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]

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

[ryan_mayu]

@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]

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

[ryan_mayu · Accepted solution]

@Zakaria_1980 

pls see the attachment below