Forum Discussion

ravi_ch's avatar
ravi_ch
Helper I
4 years ago

How can we calculate dates difference

How can we calculate no. of days between two days like 2/12/2020 - 2/20/2020 = 8,  2/20/2020 - 3/24/2020 = 32 like this
ravi_ch's avatar
ravi_ch
Helper I
4 years ago

but apply slicer like product mam it won't working.
like for each Product what is difference in days between each sale

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    ravi_ch 

    Pls try this

    Measure = 
VAR _last=maxx(FILTER(ALL('Table'),'Table'[Date]<max('Table'[Date])),'Table'[Date])
VAR _DF= DATEDIFF(_last,max('Table'[Date]),DAY)
VAR _last2=maxx(FILTER(ALL('Table'),'Table'[Date]<max('Table'[Date])&&'Table'[Product]=max('Table'[Product])),'Table'[Date])
VAR _DF2=DATEDIFF(_last2,max('Table'[Date]),DAY)
RETURN IF(ISFILTERED('Table'[Product]),_DF2,_DF)

    pls see the attachment below.