optimisation of mobile median in dax
Hello, I would like to optimise the calculation below. I guess if function or switch function would be helpfull. Do you have any recommandation ? MobileMedian3period= = ( calculate( MEDIAN(waitingtable[nNb_days_waiting_total]), filter(table_year_period, table_year_period[no_periode(row)]=1)) + calculate(MEDIAN(waitingtable[nNb_days_waiting_total]), filter(table_year_period, table_year_period[no_periode(row)]=2)) + calculate(MEDIAN(waitingtable[nNb_days_waiting_total]), filter(table_year_period, table_year_period[no_periode(row)]=3)) )/3