Forum Discussion
yaya1974
Helper III
Helper IIIFormula Help
I am trying to subtract same column but different row, or previous period. Everything I have tried keeps giving me the same value as in original column. Here is screen shot of the output I am look...
yaya1974Helper III
Helper IIII don't have in excel the screen shot below is of powerbi. I can copy the code in:
Navistar Steel Adj =
VAR PreviousDate_ =
CALCULATE(
MAX(Commodities[Date1]),
Commodities[Date1] < EARLIER(Commodities[Date1]),
ALLEXCEPT(Commodities,Commodities[Navistar Steel CRU Index Cost/lb])
)
VAR PreviousValue_ =
CALCULATE(
DISTINCT(Commodities[Navistar Steel CRU Index Cost/lb]),
Commodities[Date1] = PreviousDate_,
ALLEXCEPT(Commodities,Commodities[Navistar Steel CRU Index Cost/lb])
)
VAR CurrentValue_ = Commodities[Navistar Steel CRU Index Cost/lb]
RETURN
IF(
NOT ISBLANK(CurrentValue_) && NOT ISBLANK(PreviousValue_),
CurrentValue_ - PreviousValue_
)
The adjustment column is the only one I need help with. I got the formula to work but I need it to fill in all rows not leave zeros., but also add a 3% threshold to the formula.
example.xlsx - not sure if link will work or not.
Thank you!
Ashish_Mathur
Super User
Super UserThat link takes me to a log-in page.
- yaya1974
Sorry. I can send another pic. But basically the the code below works for me except it is not filling in all the rows. Do you know why or what I need to change to get the rows to fill in?
Thank you!
- Ashish_Mathur
Hi,
I will need a file to work with. So share the download link of the file with your Excel formulas intact.
- yaya1974
see if this link works.
Thank you