Forum Discussion

Siboska's avatar
Siboska
Helper II
3 years ago

Calculate datediff between groups and ID

Hi,  I need to calculate the DateDiff between different periods grouped by ID and per group.  Data looks like this: The measure must caluclate the datediff on planned end date per Pr...
Help appreciated
Need Help
Need Help DAX
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Siboska 

 

You can try the following methods.
Column:

Previous Planned =
MAXX (
    FILTER (
        'Table',
        [Stage] = EARLIER ( 'Table'[Stage] )
            && [Planned End Date] < EARLIER ( 'Table'[Planned End Date] )
    ),
    [Planned End Date]
)

Diff = DATEDIFF([Previous Planned],[Planned End Date],DAY)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Siboska's avatar
Siboska
Helper II
3 years ago

I need something like this: 

Where Gate Name = Stage