Calculated column on matching data

Question

Hi,&nbsp;I have to achieve&nbsp;below output in power BI,&nbsp;Where i have the data like below screen shot in same table,&nbsp;Column1&nbsp; &nbsp; &nbsp; Column2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Measure----------&nbsp; &nbsp; &nbsp; -----------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-----------ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 59EFG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp;and my requirement&nbsp;is to create new column or measure which&nbsp;gives measure value of column2, where it's matches the data with column1&nbsp;required output is&nbsp;&nbsp;Column1&nbsp; &nbsp; &nbsp; Measure&nbsp; &nbsp; &nbsp; &nbsp; New Measure/Column-----------&nbsp; &nbsp; -----------&nbsp; &nbsp; &nbsp; ---------------------------ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;59&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10EFG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp;Please suggest&nbsp;&nbsp;Thanks,Ganesh&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi Anonymous&nbsp;Try this calculated column.Calculated = CALCULATE(MAX(Ex_earlier[Measure]),FILTER(Ex_earlier, Ex_earlier[Column2]=EARLIER(Ex_earlier[Column1])))&nbsp;&nbsp;ThanksRaj

Forum Discussion

Calculated column on matching data

2 Replies

Related content

TMDL - calculated column

Matching Column Values

Table Visual not Matching Calculated Visual

Direct Lake Model - Calculated Column/Tables

Power Query or Calculated columns