Forum Discussion

Ronald123's avatar
Ronald123
Resolver III
8 years ago
Solved

Count experation days

  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 re...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Ronald123

     

    Try this MEASURE

     

    =
DATEDIFF (
    SELECTEDVALUE ( Calendar[Date] ),
    SELECTEDVALUE ( Invoices[ExperationDate] ),
    DAY
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Ronald123

 

Try this MEASURE

 

=
DATEDIFF (
    SELECTEDVALUE ( Calendar[Date] ),
    SELECTEDVALUE ( Invoices[ExperationDate] ),
    DAY
)
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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 )