Forum Discussion

Commons94's avatar
Commons94
Frequent Visitor
2 years ago

How to reference previous values from the same column where the DAX program/code is being written?

Dear Community,   I have a problem facing me since the past few months. I have multiple conditions (mentioned below) to develop 2 result columns - "Result Date" & "Result Qty". The problem I'm faci...
@Dax
@Dax help
Commons94's avatar
Commons94
Frequent Visitor
2 years ago

Hello Anonymous ,

 

thanks a lot for your reply and dax-program. It seems to work correctly for the given sample dataset but when I apply it to the complete dataset I don't get the some results where "SL Type" = "Confirmed". Can you please provide your suggestion on how the code can be altered for the following sample dataset? thanks a lot... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Commons94 ,

    Could you please provide your expected [Result Date] and [Result Qty] base on above sample data when "SL Type" = "Confirmed"? Thank you.

    Best Regards