Forum Discussion
Helper VSave date based on first status change
Guys,
Is it possible for me to create a column based on another status column, but I need it to consider/save the date of the first time the status was changed. Is it possible?
Exemple:
The detail is that in the simulation below I create lines, but when I receive them from the system, only the date is updated.
2 Replies
- amitchandak
Super User
kasife , Try a new column like
new column =
Var _min = minx(filter(Table, [Num] = earlier([Num])), [Date])
var _status = maxx(filter( Table, [Num] = earlier([Num]) && [Date] =_min), Table[Status])
return
return minx(filter(Table, [Num] = earlier([Num]) && Table[Status] <> _status), [Date])
kasifeamitchandak Thanks for your answer
Would it be possible to make a custom column in M language? I have another column that will need to be based on this first update.
