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 relationship between the tabels.

 

 

Need Help

2 Replies

  • 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 )