Datediff on unique CaseID with two different actions

[miltenburger]

Hi Guys,

I'm sturggling a bit on a calculated column which gives me the datediff.

My Table has been set up like this:

What I want to achieve is the datediff on a CaseID between "vraagverheldering" and "Besluit".

But I just don't no how to do it because the information is in the same table but on different rows in my table.

Thanks in advance guys

[sontt]

You can try:

Datedif = Calculate(max([Date]),filter(table,table[Caseid] = earlier([Caseid]) && table[Action] <> earlier(table[action]))- [date]

[miltenburger]

Thanks @sontt for your reply.

But this doesn't seems to work....

[sontt]

I tried this in my power pivot, it still work bro.

[miltenburger]

Yeah is see,

the only problem is, my action column has 100 different notations, i only want the "verheldering" and "besluit"

[sontt · Accepted solution]

you can use if function bro. Example: