Forum Discussion
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...
hi MathieuF
try to add a calculated column like:
Column =
VAR _LastTime=
MAXX(
FILTER(
data,
data[name]=EARLIER(data[name])
&&data[action]<>"auto-close"
),
data[time]
)
RETURN
IF(
[Time]=_LastTime,
1
)it worked like:
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
