Forum Discussion

Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago
Solved

Averages to populate in missing dates

Hi,   I have a table where i only have about 1 months worth of data at any given time. I would like to take the average of these values and have the average populate for Jan 2023 to current date ak...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Bryanna 

    I expected that. It's ALLSELECTED that is doing the stange things 😅

    Please try

    Measure2 =
    VAR AverageValue =
    AVERAGEX ( ALLSELECTED ( 'Calendar Table'[Date] ), [Manual Appts Calc] )
    RETURN
    SUMX (
    VALUES ( 'Calendar Table'[Date] ),
    COALESCE ( [Manual Appts Calc], AverageValue )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Bryanna 

I expected that. It's ALLSELECTED that is doing the stange things 😅

Please try

Measure2 =
VAR AverageValue =
AVERAGEX ( ALLSELECTED ( 'Calendar Table'[Date] ), [Manual Appts Calc] )
RETURN
SUMX (
VALUES ( 'Calendar Table'[Date] ),
COALESCE ( [Manual Appts Calc], AverageValue )
)

Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago

Yay, that worked!! thank you so much!