Forum Discussion
miltenburger
Helper V
Helper VDatediff on unique CaseID with two different actions
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
you can use if function bro. Example:
5 Replies
sonttResolver I
You can try:
Datedif = Calculate(max([Date]),filter(table,table[Caseid] = earlier([Caseid]) && table[Action] <> earlier(table[action]))- [date]
miltenburgerThanks sontt for your reply.
But this doesn't seems to work....
- sontt
I tried this in my power pivot, it still work bro.