Forum Discussion
DAX or Custom Column
I have a large dataset that includes DC#, UPC#, & Sale#.
I am trying to identify what the maxsale price is by UPC. I would like a column or a measure that would add to a table that will show the largest sale price for the UPC on every row. All data is in the same table. I have over a million rows here.
I dont really know what to put in the first half of the statement to have it locate the UPC.
I think the second part of the statement would be CALCULATE(MAX('TABLE[SALE$] but for the first part would it be VALUES('TABLE[UPC] or maybe FILTER('TABLE[UPC]?
I tried MAXX('TABLE[UPC] , CALCULATE(MAX('TABLE[SALES$] and that just gave me the sales price on the row but it didnt give me the Max Sales$ value by UPC.
Any help would be greatly appreciated. Thank you in advance. I should add that there are repeat UPCs in each DC and each DC has a differet sale price for the UPC
2 Replies
- lbendlinSuper User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - AnonymousNot applicable
Hi DemandMGR
Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.