How to create column based on previous value in same calculated column?

[Nick435]

Hello,

any one can help to create calculated column or measure for the "Expect" column?

thank you

[DataNinja777 · Accepted solution]

Hi @Nick435 

I think there are multiple ways to achive your required output, and the following is one of them:

You can create helper columns to get the result you need:

I attach the pbix file below:

[Nick435]

Thank you so much.  it works!!!