Hello,
You want to create a new field in your data based on a sum of cases, while grouping by Center Code and month, but without using single quotes for values. Assuming you're working with SQL or a similar query language, here's a general approach to achieve that:
SQL Approach
If you're using SQL, you can achieve this with a GROUP BY clause and SUM function. Here's a basic example: SELECT
CenterCode,
MONTH(DateColumn) AS Month,
SUM(Cases) AS TotalCases
FROM
YourTable
GROUP BY
CenterCode,
MONTH(DateColumn);
In Other Query Languages
For languages or tools like DAX in Power BI, or pandas in Python, the approach will vary slightly. Here’s how you might do it:
DAX (Power BI) NewField =
SUMX(
FILTER(
YourTable,
YourTable[CenterCode] = EARLIER(YourTable[CenterCode]) &&
MONTH(YourTable[DateColumn]) = EARLIER(MONTH(YourTable[DateColumn]))
),
YourTable[Cases]
) Pandas (Python)
import pandas as pd
# Assuming df is your DataFrame
df['Month'] = df['DateColumn'].dt.month
result = df.groupby(['CenterCode', 'Month'])['Cases'].sum().reset_index()
result.rename(columns={'Cases': 'TotalCases'}, inplace=True)
Hope that helps!
vanilla gift card balance
