Forum Discussion

Nick435's avatar
Nick435
Regular Visitor
2 years ago
Solved

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

Hello,

 

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

thank you

2 Replies

  • 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's avatar
      Nick435
      Regular Visitor

      Thank you so much.  it works!!!