How can I group together a month and get the sum of the spend for each month?

[vlruch67]

I have multiple dates for 2 months, Aug and Sept.  I want to the sum of spend for each month as a whole.

[sayyar]

@vlruch67 You can use a computed column with the month function to get the month from the date column like below:

month(@date_column@)

Additionally, if you're looking at data across different years, you could do a concatenate function to get the month and year like below:

concatenate(year(@date_column@), month(@date_column@))

Once you have this, the next step to perform is a "Shape" operation, and specifically "Group By". 

Here's a link to the help documentation for Group By shaping operation: https://paxata.atlassian.net/wiki/spaces/PaxDocs/pages/539787368/Data+Shaping+Tools+explained#DataSh...