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 custome...
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))

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