Count experation days

[Ronald123]

Hello,

I'm looking for a measure for the follow issue.

I need the difference of total days between de exparation date and the selected date in the slicer.

In the model there's isn't an relationship between the tabels.

[Zubair_Muhammad · Accepted solution]

@Ronald123

Try this MEASURE

=
DATEDIFF (
    SELECTEDVALUE ( Calendar[Date] ),
    SELECTEDVALUE ( Invoices[ExperationDate] ),
    DAY
)

[Zubair_Muhammad]

@Ronald123

or this one

=
VAR Start_Date =
    MIN (
        SELECTEDVALUE ( Calendar[Date] ),
        SELECTEDVALUE ( Invoices[ExperationDate] )
    )
VAR End_Date =
    MAX (
        SELECTEDVALUE ( Calendar[Date] ),
        SELECTEDVALUE ( Invoices[ExperationDate] )
    )
RETURN
    DATEDIFF ( Start_Date, End_Date, DAY )