Calculated column by combining 2 other columns where column A is ref column has duplicate distinct values. If column B has result any row for that specific Ref in column then same should be the result and will not overwrite the column C if any row is blank from column B. If column B is blank for all ref as per column A then column C result should come in end result.
| Column A | Column B | Column C |
|---|---|---|
| India | ||
| China | T1 | |
| India | T2 | T3 |
| China | T4 | |
| Russia | T3 | |
| Russia | ||
| Rome | T2 | |
| Japan | T1 | |
| Rome | ||
| Japan | T3 |
| Column A | Column B | Column C | Result |
|---|---|---|---|
| India | |||
| China | T1 | T1 | |
| India | T2 | T3 | T2 |
| China | T4 | ||
| Russia | T3 | T3 | |
| Russia | T0 | ||
| Rome | T2 | T2 | |
| Japan | T1 | T1 | |
| Rome | |||
| Japan | T3 |
on the table view create a column with an IF statement so if column B is blank use column C
Result = IF(NOT(ISBLANK(TableName[ColumnB])), TableName[ColumnB], TableName[ColumnC])