Forum Discussion
Solved
Help with calculated column
I have a table with the 3 first columns and want to calculate the fourth column. Which DAX-function? Client Parent Client Client Responsible Parent Client Responsible 1 1 A C 2 1 ...
Oops , mistake in copying the formula... corrected... you can check now
Oops , mistake in copying the formula... corrected... you can check now
Your formula is perfectly correct. It was my initial table that was wrong. Very sorry for that. It should have read like this instead, i.e. Parent Client Responsible for Parent Client 1 should be A and not C, see below. Thus, the client that is the parent client determines Parent Client Responsible.
| Client | Parent Client | Client Responsible | Parent Client Responsible |
| 1 | 1 | A | A |
| 2 | 1 | A | A |
| 3 | 1 | C | A |
| 4 | 4 | D | D |
| 5 | 5 | E | E |
| 6 | 8 | A | F |
| 7 | 8 | C | F |
| 8 | 8 | F | F |
| 9 | 9 | G | G |
| 10 | 9 | H | G |