Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference between MAX date and another date

Hi folks,   I am struggling with a DAX expression to get the difference between the max date in a slicer and the date of the invoices, I mean:   I have a table with clients, invoices and dates: ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create two measures to get it.

    max date =
MAXX ( ALLSELECTED ( 'Date'[Date] ), 'Date'[Date] )

    Days =
DATEDIFF ( SELECTEDVALUE ( 'Table'[Date] ), [max date], DAY )

    Here is the result.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could create two measures to get it.

max date =
MAXX ( ALLSELECTED ( 'Date'[Date] ), 'Date'[Date] )

Days =
DATEDIFF ( SELECTEDVALUE ( 'Table'[Date] ), [max date], DAY )

Here is the result.

Here is my test file for your reference.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-eachen-msft 

     

    could it be possible to do it in a column instead of doing it in a measure?  The reason is that I want to use this calculated value in a selector.