Forum Discussion
Calculated column based on other columns
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 ...
Anonymous , Try a new column like
new column =
var _1 = countx(filter(Table, [Place] =earlier([place]) && [Status] ="High"),[Month])
return
if( isblank(_1), "Low", "High")
Anonymous , Try a new column like
new column =
var _1 = countx(filter(Table, [Place] =earlier([place]) && [Status] ="High"),[Month])
return
if( isblank(_1), "Low", "High")
Thanks Amit.. its working.