Forum Discussion

ctien's avatar
ctien
New Member
2 years ago
Solved

Advanced Power Query - Group by dataset including Start Date and End Date

HI,   I have below Source dataset    Source data Employee ID Function Start Date End Date Days A001 PM 2024-01-01 2024-01-31 31 A001 PM 2024-02-01 2024-02-15 15 A001 C...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Try adding the final parameter for the Table.Group function. Before the end parentheses, add ", GroupKind.Local".

     

    --Nate