Forum Discussion

MathieuF's avatar
MathieuF
Helper III
3 years ago

Find the previous action

Hello, In power bi, I would like a column calculated in dax which puts a 1 on the last action which precedes the auto-close action of the same ID. The table is called Journal, the time column is ti...
MathieuF's avatar
MathieuF
Helper III
3 years ago

Hello FreemanZ ,

Thank you very much, I will test.
Why does the formula include the name? Knowing that a person can have several IDs at the same time.
I think that it is rather necessary to insert the notion of ID.
Mat
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi MathieuF 

you know your dataset best. please feel free to change name to id.

  • MathieuF's avatar
    MathieuF
    Helper III
    3 years ago

    FreemanZ 

    The results are not good.
    I am currently having a problem accessing the table.
    When I have new access, I will see what is causing the problem.
    Small question, should the table be sorted?

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      hi MathieuF 

      what error do you get?

      Sort will not change anything in most DAX occassions.

      • MathieuF's avatar
        MathieuF
        Helper III
        3 years ago

        Hello FreemanZ 
        I'll screenshot the problem for you.
        I will privately send you the model with the data.
        Is it related to the sorting of updated-at?