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 |
| 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
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")
2 Replies
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")