Forum Discussion

villa1980's avatar
villa1980
Resolver II
2 years ago
Solved

Min and All except in Power Query

Hi All,    I am trying to replicate a DAX expression within Power Query which I can then use to filter the underlying data, however, when trying to replicate it within Power Query I am getting blan...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    NewStep=let a=Table.Group(YourTable,"Combination",{"min",each List.Min([Index])}) in Table.AddColumn(YourTable,"MinIndex",each a{[Combination=[Combination]]}[min])

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

NewStep=let a=Table.Group(YourTable,"Combination",{"min",each List.Min([Index])}) in Table.AddColumn(YourTable,"MinIndex",each a{[Combination=[Combination]]}[min])

villa1980's avatar
villa1980
Resolver II
2 years ago

Hi wdx223_Daniel,
Thanks for the reply, wow that is quite complicated compared to DAX 🙂

I have added the column with your formula but unfortunately still comes back blank. I have included the screenshot below to show it.

So as you can see I have many lines for 2 entities in the Combinations Column, would like it to say 1 as the Min Index

 

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    2 years ago

    Hi villa1980 

     

    To resolve the issue, share your implementation of the provided solution by wdx223_Daniel and make sure that code section includes at least the previous and next step as well

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

    could you please show your hard code?