Calculated column based on other columns

[ghosh_kavitha]

Hi 

here is my data set. i need to add calculated column based on the other two column."Place ""Status"

Month	Place	Status
March	Chennai	High
April	Chennai	Low
May	Chennai	Low
March	Kolkata	High
April	Kolkata	High
March	delhi	Low
April	delhi	Low
May	delhi	High
March	Mumbai	Low
May	Mumbai	Low
March	Bangalore	Low
May	Bangalore	Low

need my result column

Month	Place	Status	Result
March	Chennai	High	High
April	Chennai	Low	High
May	Chennai	Low	High
March	Kolkata	High	High
April	Kolkata	High	High
March	delhi	Low	High
April	delhi	Low	High
May	delhi	High	High
March	Mumbai	Low	Low
May	Mumbai	Low	Low
March	Bangalore	Low	Low
May	Bangalore	Low	Low

ex - if i filter chennai ,the status column shows different status then the result will be "high".

can some one help to figure out the measure.

thanks

Kavitha 

[amitchandak · Accepted solution]

@ghosh_kavitha , Try a new column like

new column =
var _1 = countx(filter(Table, [Place] =earlier([place]) && [Status] ="High"),[Month])
return
if( isblank(_1), "Low", "High")

[ghosh_kavitha]

Thanks Amit.. its working.