I'm very well versed in Excel, but very new to PowerPivot. I have a data set which includes game logs for every NBA player for every game of the season, and I want a new column which calculates the aggregate minutes played by a player's team on a given night.

In Excel this would be a simple SUMIF: `[Minutes] if [Team] = [@Team] and [Date] = [@Date]`

How would I approach this in PowerPivot, or is this something I would need to do before importing the data into PowerPivot?