Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Populate value based on MAX value from another column

Hi everyone,

 

I'd like to populate, for each product row, the value in the Units column that's aligned to the maximum percentage for each product. The results I'd like to see are in the Max Units column shaded blue.

 

Kudos to anyone who can help!

 

 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    DAX

    Max Units=MAXX(TOPN(1,FILTER(Table,Table[Product]=EARLIER(Table[Product])),Table[Percentage]),Table[Units])

    M

    NewStep=Table.Combine(Table.Group(PreviousStepName,"Product",{"n",each let a=Table.Max(_,"Percentage")[Units] in Table.AddColumn(_,"Max Units",each a)})[n])

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

    DAX

    Max Units=MAXX(TOPN(1,FILTER(Table,Table[Product]=EARLIER(Table[Product])),Table[Percentage]),Table[Units])

    M

    NewStep=Table.Combine(Table.Group(PreviousStepName,"Product",{"n",each let a=Table.Max(_,"Percentage")[Units] in Table.AddColumn(_,"Max Units",each a)})[n])