Forum Discussion
How to replace the same value based on the two columns
HI,
Can anyone please help me out the below issue?
I have the data like below, and i want to replace the second column data using the first column.
| Column1 | Column2 | Replace the value in Column2 |
| 191622-082 | III | |
| 191622-082 | III | |
| 191622-094 | III | |
| 191622-094 | III | |
| 191622-117 | IV | |
| 191622-117 | IV | |
| 191622-120 | III | |
| 191622-120 | III | |
| 191622-121 | III |
I have the data for Column1 and Column2, if column1 has same values but column2 has only one value for those same column1 values.
Column3 is the data which we need to replace in column2 blank values(Just for reference i added)
i want to replace same Column2 values for all the same column1 values.
Thanks,
kapil
Just create a calculated column like below;
Column = IF ( Table3[Column2] = BLANK (), CALCULATE ( MAX ( Table3[Column2] ), FILTER ( Table3, Table3[Column1] = EARLIER ( Table3[Column1] ) && Table3[Column2] <> BLANK () ) ), BLANK () )Regards,
3 Replies
Just create a calculated column like below;
Column = IF ( Table3[Column2] = BLANK (), CALCULATE ( MAX ( Table3[Column2] ), FILTER ( Table3, Table3[Column1] = EARLIER ( Table3[Column1] ) && Table3[Column2] <> BLANK () ) ), BLANK () )Regards,
HI Simon,
Thank you so much your repose..!
Its working fine, Now i am seeing if value is there is Column2 that value i am seeing NULL in column3, but that is not requirment
Even Column2 value also displayed in Column3.
Phase = IF(LaunchPadData[Study Phase] = BLANK(),CALCULATE(MAX(LaunchPadData[Study Phase]),FILTER(LaunchPadData,LaunchPadData[Study Number] = EARLIER(LaunchPadData[Study Number]) && [Study Phase] <> BLANK())),BLANK())
Looks i gave the requirment wrongly.
sorry for that.
Please help me out.
Thanks,
Kapil
Thank you Simon,
I got the solution.
Thanks,
kapil