Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

power query group-by data until state change

Hello I have a problem that I hope someone can help with a solution. I have a table looks like> Device,       StartUtc,                        EndUtc,                        State ABC         2/5...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi Anonymous 

     

    in the Group formula, for the last argument use GroupKind.Local instead of GroupKind.Global

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous 

 

in the Group formula, for the last argument use GroupKind.Local instead of GroupKind.Global

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    you saved my day.

    so simple, I wasn\t aware on the groupkind.

     

    Thanks a lot