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 ...
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])

Anonymous's avatar
Anonymous
Not applicable
2 years ago

wdx223_Daniel  Perfect, thank you.