Forum Discussion

miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
8 years ago
Solved

Datediff 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 ...
Need Help
  • sontt's avatar
    sontt
    8 years ago

    you can use if function bro. Example:

sontt's avatar
sontt
Icon for Resolver I rankResolver I
8 years ago

You can try:

 

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

miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
8 years ago

Thanks sontt for your reply.

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

  • sontt's avatar
    sontt
    Icon for Resolver I rankResolver I
    8 years ago

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

    • miltenburger's avatar
      miltenburger
      Icon for Helper V rankHelper V
      8 years ago

      Yeah is see,

       

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

      • sontt's avatar
        sontt
        Icon for Resolver I rankResolver I
        8 years ago

        you can use if function bro. Example: