Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
pls see the attachment below
Proud to be a Super User!
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)
Proud to be a Super User!
This is what i'm getting as error, could you help me please
maybe try
Column 2 =
VAR _max=CALCULATE(max(sheet1(var v]),ALLEXCEPT('sheet1','sheet1'[project name]))
return if('sheet1'[var v]=_max,1,0)
Proud to be a Super User!
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
pls see the attachment below
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |