Comparing Slicer date and column date

[Anonymous]

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.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Take a try of this one: 

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

[Mariusz]

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.