I'd like to find the median of the purchase price of the delivery in the weekly sales amount.

[ag779655]

work 

MAXX(
                 filter ('purchase data',
                 VALUE('Purchase Data' [Product Number])=ValUE('Sales Data' [Product Number])&&
                 'Buy Data' [day]= ('Consolidated Purchase Week' [day])&&
                 'Purchased Data' [market]= 'Sales Data' [market]), 'Purchased Data' [Product Unit Price])

didn't work

MEDIANX or AVERAGEX(
                 filter ('purchase data',
                 VALUE('Purchase Data' [Product Number])=ValUE('Sales Data' [Product Number])&&
                 'Buy Data' [day]= ('Consolidated Purchase Week' [day])&&
                 'Purchased Data' [market]= 'Sales Data' [market]), 'Purchased Data' [Product Unit Price])

data type sell (weekly)

     day(week)         Product Number   market    sell data(weekly)

    2021-1-3                 45875               market1       4,500

    2021-1-10               45875              market1       4,500

data type buy (weekly)

     day(weekly)       Product Number   market    sell data(weekly)

      2021-1-3                45875                  market1       3600

       2021-1-10               45875                  market1       3600

In addition, I would like to obtain the median value by adding the data of the month corresponding to the week and the previous month. I wonder if this is possible and the solution. Please help me.

Thank you for letting me know if there is a similar case.

(I posted it on another board, but there was no answer, so I thought I was mistaken.)

[daxer-almighty]

"I posted it on another board, but there was no answer, so I thought I was mistaken."

Not only were you mistaken. You're very likely not to get any answers here, either (it's already Sunday). If you want to know why, please read this: How to Get Your Question Answered Quickly - Microsoft Power BI Community