Difference bewteen Max date and todays date in a data set

[Anonymous]

Hi Experts

I have the following sample data extract as shown..

i have added the following as a calculated column to the above table

Maxdate =

CALCULATE (

MAX ( DH_AUDITCONTENTIMPORT[Date] ),

ALLEXCEPT ( DH_AUDITCONTENTIMPORT, DH_AUDITCONTENTIMPORT[Product] )

)

now i am trying to work out the datediff between the max date less todays() date. which i am have trouble with.

[amitchandak]

Did not get it completely

Try
Maxdate =

var _1 =CALCULATE (
MAX ( DH_AUDITCONTENTIMPORT[Date] ),
ALLEXCEPT ( DH_AUDITCONTENTIMPORT, DH_AUDITCONTENTIMPORT[Product] )
)
return
datediff(_1, today()-1,Day)

[Anonymous]

Hi Amrit

Lets take company a, and product book the max date is 3/3/2020, so this less todays date show give us 8 days. 

[v-lionel-msft · Accepted solution]

Hi  @Anonymous ,

Here's my sample data (the values of my date column are different from yours.):

For your problem, I suggest you use measure:

Days = 
VAR x = 
CALCULATE(
    MAX([Date]),
    ALLEXCEPT(
        DH_AUDITCONTENTIMPORT,
        DH_AUDITCONTENTIMPORT[Company], DH_AUDITCONTENTIMPORT[Product]
    )
)
RETURN
DATEDIFF(
    x,
    TODAY(),
    DAY
)

Best regards,
Lionel Chen

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

[Anonymous]

Can you share whats the expected output?