Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ag779655
Regular Visitor

medianx by filter plz help

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.

 

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.