Forum Discussion

summit20's avatar
summit20
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate between rows based on another column

I have a bid sheet with raw bid data as shown in the table below. Every project I enter my bid and am always the top bidder in the row (CCI). I am trying to create another column that shows the diffe...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    summit20 , try like

    Difference = var _1 = Minx(filter(Sheet1,[Project #] =EARLIER([Project #]) && Sheet1[Bidder]="CCI"),[Bid Amount])
return if(ISBLANK(_1),BLANK(),[Bid Amount]-_1)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

summit20 , try like

Difference = var _1 = Minx(filter(Sheet1,[Project #] =EARLIER([Project #]) && Sheet1[Bidder]="CCI"),[Bid Amount])
return if(ISBLANK(_1),BLANK(),[Bid Amount]-_1)
summit20's avatar
summit20
Icon for Helper I rankHelper I
6 years ago

That worked!!! Thank you so much!!! Any good resource to help understand how you built this and the logic for this formula to help me better learn PowerBI?