Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Comparing Slicer date and column date

Hi

I want to use a date slicer, which returns one date, to calculate the number of days between each transaction date and the selected slicer date, this to accomodate for an option to show a customer aging report as it was on a given date.

 

My issue is that this works 100%:

 

Daysbetween = date(2019;6;30)-'Date'[Date]

While this doesnt work

 

 

SelectedDate = SELECTEDVALUE(PerDateTable[PerDate])
DaysbetweenMeasureinput = [SelectedDate]-'Date'[Date]

event though I know [SelectedDate] returns the same date 30.06.2019

 

I understand this has to do with context, but is there any way to achieve this?

 

Any pointers are appreciated.

 

 

Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Take a try of this one: 

    Measure = MAXX('Date',DATEDIFF([Date],SELECTEDVALUE(PerDateTable[PerDate]),DAY))

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    You can create a measure to calculate this, something like below.

     

    DaysbetweenMeasureinput = 
SUMX( Dates, SELECTEDVALUE( DatePicker[Date] ) - Dates[Date] ) * 1

    See the attached file for reference.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski


     

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Take a try of this one: 

    Measure = MAXX('Date',DATEDIFF([Date],SELECTEDVALUE(PerDateTable[PerDate]),DAY))