Forum Discussion

Nepal101's avatar
Nepal101
Helper III
2 years ago

Calculating days between dates in same column

Hello Everyone,  I have a question regarding how to calculate the column or Measure that gives me days between dates Date ClientName salesperson Days Between Running total days or sum days ...
Need Help
Show and Tell
danextian's avatar
danextian
Super User
2 years ago

Hi Nepal101 ,

Assuming that the days difference is to be calculated by client name:

Days Diff = 
VAR __PREV =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER (
            'Table',
            'Table'[Date] < EARLIER ( 'Table'[Date] )
                && 'Table'[ClientName] = EARLIER ( 'Table'[ClientName] )
        )
    )
RETURN
    DATEDIFF ( __PREV, 'Table'[Date], DAY ) + 0

Otherwise, remove this line:

&& 'Table'[ClientName] = EARLIER ( 'Table'[ClientName] )

 

Nepal101's avatar
Nepal101
Helper III
2 years ago

Hello danextian, 
Thank you so much for your help and time. 
is there a way to calculate the running total for the days as well please. 
Can the days be sum up for each rows ?