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
  • DataNinja777's avatar
    2 years ago

    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: