Forum Discussion

kapil512's avatar
kapil512
Icon for Helper II rankHelper II
8 years ago
Solved

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 ...
Interesting Links
Need Help
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
kapil512
Icon for Helper II rankHelper II
8 years ago

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's avatar
    kapil512
    Icon for Helper II rankHelper II
    8 years ago

    Thank you Simon,

     

    I got the solution.

     

    Thanks,

    kapil