NaginFrequent Visitor4 years agoSolvedWhole Month Activity Hi, I am trying to create a DAX measure to median and mean to show only whole month activity, as per the chart below, the trend dips in July as it does not include the full month data, internally...Show MoreFowmy4 years agoNagin I made the measure for Mean, you can repeat the same for Median LOS Mean = IF( EOMONTH( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]),0) <= CALCULATE( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]), REMOVEFILTERS(ECDS)) , AVERAGE(ECDS[Hospital_Spell_Duration_D]) )
Fowmy4 years agoNagin I made the measure for Mean, you can repeat the same for Median LOS Mean = IF( EOMONTH( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]),0) <= CALCULATE( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]), REMOVEFILTERS(ECDS)) , AVERAGE(ECDS[Hospital_Spell_Duration_D]) )
Fowmy4 years agoNagin I made the measure for Mean, you can repeat the same for Median LOS Mean = IF( EOMONTH( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]),0) <= CALCULATE( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]), REMOVEFILTERS(ECDS)) , AVERAGE(ECDS[Hospital_Spell_Duration_D]) )
FowmySuper User4 years agoNagin I made the measure for Mean, you can repeat the same for Median LOS Mean = IF( EOMONTH( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]),0) <= CALCULATE( MAX(ECDS[Admission_Date_Hospital_Provider_Spell]), REMOVEFILTERS(ECDS)) , AVERAGE(ECDS[Hospital_Spell_Duration_D]) )
Related contentCounting Active employees per monthCreating ICMs via ActivatorActivity StatisticsFabric pipeline activities web activity Oauth errorActivator Teams Alert
