medianx by filter plz help

[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 (montly)

     day(month)         Product Number   market    sell data(montly)

       2021-1-1               45875                  market1       3600

       2021-2-1               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.

[V-lianl-msft]

I don't quite understand the scenario. Could you please provide the results you expect?

[amitchandak]

@ag779655 , with the data shared I am not able to connect to the formula.

Can you share sample data and sample output in table format?

Are you creating a new column ?

refer if needed

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8