Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Same wareID with different prices

Hey,  I have a bit of an interesting (perhaps simple) predicament, where I have duplicate values in my dataset because some WareIDs have different prices depending on the amount sold. See example ...
Need Help
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Anonymous ,

 

Could you group the columns in powerquery and return a max and minof prices 1 & 2 in it?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi davehus 

    Hm, good idea. I'll mess around with it. Thanks for the input.