Forum Discussion

vedantaher's avatar
vedantaher
Copper Contributor
Sep 04, 2023

Group by in excel

I have multiple values for each date of Jan. month and i need total of values for each date how can i go about this is there any other option than writing power query? 
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Sep 04, 2023

vedantaher 

For an arbitrary number of 'Type's you could use

= LET(
    distinctDates, UNIQUE(Table1[Date]),
    totalsByDate,  BYROW(distinctDates, 
      LAMBDA(date,
        SUM(FILTER(DROP(Table1,,1), Table1[Date] = date))
      )
    ),
    HSTACK(distinctDates, totalsByDate)
  )

 

Resources