Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Calculated Column - Last Entry per Sales Order

Hi experts! I have a table that shows me the value for each sales order for the respective state: Order Number Status Value 100 50 5 100 66 5 100 80 4 100 95   101 50 ...
Need Help
  • Dhacd's avatar
    Dhacd
    4 years ago

    Hi joshua1990 

     



    Try the below code

    NullValueFill = 
Var _Status = 'Table'[Status]
Var _Value ='Table'[Value]
Var _PreviousStatus = maxx(filter('Table','Table'[Status]<_Status),'Table'[Status])
Var _PreviousValue = CALCULATE(Max('Table'[Value]),filter('Table','Table'[Status]=_PreviousStatus))
Var result = If(isblank(_Value),_PreviousValue,_Value)
Return result

    If there is any issue please reply.

    If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
    Regards,
    Atma.

Dhacd's avatar
Dhacd
Icon for Resolver III rankResolver III
4 years ago

Hi joshua1990 

 



Try the below code

NullValueFill = 
Var _Status = 'Table'[Status]
Var _Value ='Table'[Value]
Var _PreviousStatus = maxx(filter('Table','Table'[Status]<_Status),'Table'[Status])
Var _PreviousValue = CALCULATE(Max('Table'[Value]),filter('Table','Table'[Status]=_PreviousStatus))
Var result = If(isblank(_Value),_PreviousValue,_Value)
Return result

If there is any issue please reply.

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Regards,
Atma.