Take the average for the particular date and populate across other dates

[adharsr]

I have the table which has a column pricedate in it, and another table which has calendar date in it. I have to calculate the average price of the maximum pricedate and populate across other dates.
daxused = 

var folderdate = MAX('Append'[pricedate])

return  CALCULATE(AVERAGE('Append'[price]),ALLEXCEPT('calenderDate','calenderDate'[Date]),'calenderDate'[Date]=folderdate)

which calculates average Append[price] for each calenderDate[Date]

what is expected is 

thanks for your help!

[Anonymous · Accepted solution]

Hi @adharsr ,

You can update the formula of measure [daxused] as below and check if it can return the correct result...

daxused =
VAR folderdate =
    CALCULATE ( MAX ( 'Append'[pricedate] ), ALLSELECTED ( 'Append' ) )
RETURN
    IF (
        SELECTEDVALUE ( 'calenderDate'[Date] ) IN VALUES ( 'Append'[pricedate] ),
        CALCULATE (
            MAX ( 'Append'[price] ),
            FILTER ( ALLSELECTED ( 'Append' ), 'Append'[pricedate] = folderdate )
        )
    )

Best Regards

[adharsha]

Thank you so much my problem is solved, heartful thanks to you 😄