Forum Discussion

Sandeep_1992

Regular Visitor

1 year ago

Solved

Referring Same Column - Previous Value

Hi Everyone, Question : Can we refer to same column previous value in power bi calculated column ? Like in excel if i need to calculate a cell value i can refer to the cell value above and calcu...

v-lgarikapat
1 year ago
Hi Sandeep_1992 ,

Thanks for reaching out to the Microsoft fabric community forum

To help us understand your issue better, please share sample data that clearly shows the problem (in text or table format, not a screenshot), without including any sensitive or unrelated information, and also show the expected result based on that data. If possible, share the PBIX file as well, provided it doesn’t contain any sensitive information.

Looking forward to your response.

Best Regards,

Lakshmi Narayana

Sandeep_1992

Regular Visitor

1 year ago

Column 1 = which i mentioned is in the NewOffer_Amount S.no 1 as Column 1 the value is 99

Cycle time = I dont have in the table its a static input like 3 months or 6 months i can be changed

Below excel snapshot i want to build that in power bi - the formula i want is = =IF(AND(D24=$H$6;E24=$H$7);'ST'!$T$88;IF(OR(D24>$H$6;E24>$H$7);N23*($I$10-1)/$I$10+P23;0))

D24 = Month

E24 = Month

ST T88 - I have a measure which gives this value lets say it 66

N23 = Same Column above row ( For eg:- I'm calculating n24 its n23, n25 then its n24)

I10 = Cycle time, which is again a measure value i want to add

p23 = last column in the excel newly generated per month fields - Amount Column ( This value also to be takne previous cell like for N24 it should take p23)