How to replace the same value based on the two columns

[kapil512]

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

[v-sihou-msft · Accepted solution]

@kapil512

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,

[kapil512]

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

[kapil512]

Thank you Simon,

I got the solution.

Thanks,

kapil