Grouping Sales by Month

[DavidMadalyn]

Hi All,

I have a table of sales records, I have another table where I’m trying to aggregate the total sales for each month

SELECT(
  Auctions[Hammer],
  CONCATENATE(Auctions[Year], Auctions[Month]) = CONCATENATE([Year], [Month]),
  FALSE
)

I’m just getting nothing back, I’m lost … TIA

[OptimiX_XcrY]

SELECT(

Auctions[Hammer],

CONCATENATE([Year], [Month]) = CONCATENATE([_thisrow].[Year], [_thisrow].[Month]),

FALSE

)

[DavidMadalyn]

Thank you so very much works perfectly