Forum Discussion
COPY VALUE FROM ANOTHER COLUMN
Dear
Find below Table Values & Output view
Current Table - If Ref & ID both are same copy claim amount to ID aslo
| Table 1 | ||||||
| ID | Name | Service | Class | Food | Ref | Claims |
| 125 | XXXX | NNN | 3 | NV | 0 | |
| 126 | YYYY | UUU | 2 | V | 125 | 150 |
| 128 | VVVV | MMM | 3 | NV | 0 | 120 |
| 129 | SSSS | RRRR | 1 | V | 0 | 129 |
| 130 | AAA | CCC | 2 | NV | 0 | |
| 131 | KKK | BBB | 1 | NV | 130 | 80 |
| 132 | PPPP | LLLL | 1 | NV | 130 | 85 |
OutPut
| Table 1 | |||||||
| ID | Name | Service | Class | Food | Ref | Claims | |
| 125 | XXXX | NNN | 3 | NV | 0 | 150 | |
| 126 | YYYY | UUU | 2 | V | 125 | 150 | |
| 128 | VVVV | MMM | 3 | NV | 0 | 120 | |
| 129 | SSSS | RRRR | 1 | V | 0 | 129 | |
| 130 | AAA | CCC | 2 | NV | 0 | 80 | (1st value) |
| 131 | KKK | BBB | 1 | NV | 130 | 80 | |
| 132 | PPPP | LLLL | 1 | NV | 130 | 85 |
Your Query is not clear. Can you please provide some more inforamtion along with a single example.
4 Replies
- rocky09
Solution Sage
Your Query is not clear. Can you please provide some more inforamtion along with a single example.
Column ID is Mother ID
Coumn REF is Child ID -
But Claim amount mentioned at Child ID
same will copy to Mother ID
rocky09 wrote:Your Query is not clear. Can you please provide some more inforamtion along with a single example.
v-frfei-msftCommunity Support
Hi Anonymous ,
To ceate a measure as below.
Measure = IF ( ISBLANK ( MAX ( Table1[Claims] ) ), CALCULATE ( FIRSTNONBLANK ( Table1[Claims], SUM ( Table1[Claims] ) ), FILTER ( ALL ( Table1 ), Table1[Ref] = MAX ( Table1[ID] ) ) ), MAX ( Table1[Claims] ) )Regards,
Frank