Forum Discussion
RubenMerino
2 years agoFrequent Visitor
DATEDIFF based on measure
Hi
I have two table:
- Calendari_des_de_2018: And this table it's only a calendar table.
- 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
- Greg_DecklerCommunity Champion
RubenMerino Seems like:
Measure = ( MAX('Llista_Espera'[Data Baixa]) - [Data_maxima_seleccion_filter] ) * 1.- RubenMerinoFrequent Visitor
- RubenMerinoFrequent Visitor