Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |