Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Delete Hard Coded Columns after PowerQuery GroupBy

Hello Everyone,    Down below I've shared my groupby statement.      In PowerQuery M this is the code:   #"Groupby Casenummer for min_wo" = Table.Group(#"Type to date", {"CaseNumber"}, ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    Did you mean to make the grouped table structure dynamic changes instead of auto generated by M query functions?
    If that is the case, you can try to remove the table structure parts, then the result will be recognized as common table type without detailed definitions.

     

    #"Groupby Casenummer for min_wo" = Table.Group(#"Type to date", {"CaseNumber"}, {{"Min Werkordernummer", each List.Min([wo_number]), type nullable text}, {"ALL", each _, type table}})

     

    Notice: power query will cache the table structure into the query steps and not auto sync. So if your source structure changes, you need to manually check each step to fix the issue caused by these cache structures.

    Regards,

    Xiaoxin Sheng