Forum Discussion

RubenMerino's avatar
RubenMerino
Frequent Visitor
2 years ago
Solved

DATEDIFF based on measure

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. 

3 Replies