Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
You can try:
Datedif = Calculate(max([Date]),filter(table,table[Caseid] = earlier([Caseid]) && table[Action] <> earlier(table[action]))- [date]
I tried this in my power pivot, it still work bro.
Yeah is see,
the only problem is, my action column has 100 different notations, i only want the "verheldering" and "besluit"
you can use if function bro. Example:
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |