Forum Discussion

DemandMGR's avatar
DemandMGR
Helper I
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.