Forum Discussion

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper 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...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi MathieuF 

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

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper 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
    Icon for Super User rankSuper User
    3 years ago

    hi MathieuF 

    what error do you get?

    Sort will not change anything in most DAX occassions.

    • MathieuF's avatar
      MathieuF
      Icon for Helper III rankHelper 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?