Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated column on matching data

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 ----------      -----------         ---...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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