Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I don't quite understand the scenario. Could you please provide the results you expect?
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |