Showing results for 
Search instead for 
Did you mean: 

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

Image Sensor
I have multiple dates for 2 months, Aug and Sept.  I want to the sum of spend for each month as a whole.
Labels (1)
0 Kudos
1 Reply
Linear Actuator
@vlruch67 You can use a computed column with the month function to get the month from the date column like below:

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:

0 Kudos