DATEDIFF based on measure

[RubenMerino]

Hi 

I have two table:

1. Calendari_des_de_2018: And this table it's only a calendar table.
2. Llista_Espera: And this table has mean data.

I need measure , the name IE01, that count de difference of day between de column "Data Baixa" of Llista_Espera table and the value of "Data_maxima_seleccio_filtre" than has the funcion "Data_maxima_seleccio_filtre = LASTDATE(Calendari_des_de_2018[Date])".

The idea is, when you us the slider to filter a day the function "Data_maxima_seleccion_filter" take the lastdate and them in the measure of difference of day between change the number of difference day.

This is the final table than I need.

Thanks. 

[Greg_Deckler]

@RubenMerino Seems like:

Measure = 
  ( MAX('Llista_Espera'[Data Baixa]) - [Data_maxima_seleccion_filter] ) * 1.

[RubenMerino · Accepted solution]

Hi @Greg_Deckler 

Finally
I point that I forget, I delate de relation between tables 

[RubenMerino]

Hi @Greg_Deckler 

First, thank very much for answer so fast

But I think it dosen't work