calculate no of days difference in date column in power bi measure

[Anonymous]

Hi Team,

Can you help me on how to calculate no of days difference in date column using power bi measure?

Thanks,

Vasu.

[ERD]

Hi @Anonymous ,

Here is one of the options:

Time Difference Measure =
VAR PrevRow =
    CALCULATE (
        MAX ( T[Date] ),
        FILTER ( ALL ( T[Date] ), T[Date] < SELECTEDVALUE ( T[Date] ) )
    )
RETURN
    IF (
        HASONEVALUE ( T[Date] ),
        COALESCE ( DATEDIFF ( SELECTEDVALUE ( T[Date] ), PrevRow, DAY ) * -1, 0 )
    )

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

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

Diff between dates =
VAR ranking =
RANKX ( ALL ( 'Table'[Date] ), CALCULATE ( MAX ( 'Table'[Date] ) ),, DESC )
VAR previousrank = ranking + 1
VAR previousinfo =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER (
ALL ( 'Table'[Date] ),
RANKX ( ALL ( 'Table'[Date] ), CALCULATE ( MAX ( 'Table'[Date] ) ),, DESC ) = previousrank
)
)
RETURN
IF (
ISFILTERED ( 'Table'[Date] ),
COALESCE ( DATEDIFF ( previousinfo, MAX ( 'Table'[Date] ), DAY ), "" )
)

https://www.dropbox.com/s/dgmnhr0jbht3tus/srinu.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM