Calculated column on matching data

[Anonymous]

Hi,

I have to achieve below output in power BI,

Where i have the data like below screen shot in same table,

Column1      Column2           Measure

----------      -----------         -----------

ABC                 XYZ                    59

EFG                 ABC                   10

and my requirement is to create new column or measure which gives measure value of column2, where it's matches the data with column1

required output is 

Column1      Measure        New Measure/Column

-----------    -----------      ---------------------------

ABC                 59                    10

EFG                 10                     -

Please suggest 

Thanks,

Ganesh

[Anonymous · Accepted solution]

Hi @Anonymous

Try this calculated column.

Calculated = CALCULATE(MAX(Ex_earlier[Measure]),FILTER(Ex_earlier, Ex_earlier[Column2]=EARLIER(Ex_earlier[Column1])))

Thanks

Raj

[Anonymous]

Thanks Raj for looking into this.

In my real time scenarion, if i am taking aggragtion as SUM, It's working perfectly.

Best Regards,

Ganesh