Accruing values weekly

Hi Jeff2Jets ,

When you import your weekly .csv files into Power BI, consolidate them into a single table. You can do this by using Append Queries in Power Query following bellow steps:

Import the .csv files for Week 1 and Week 2 into Power BI.
Go to Power Query and Select Home > Append Queries and append all weekly tables into a single table.
Note: Use the combined table as your main dataset. This ensures all new data is automatically added on refresh.

Now create a summarized table to calculate the total calls for each employee:

EmployeeCalls = 
SUMMARIZE(
    'CombinedTable',
    'CombinedTable'[Employee Name],
    'CombinedTable'[Department],
    "Total Calls", SUM('CombinedTable'[# of Calls])
)

When you add new rows in the .csv files, they will automatically be included during the refresh because you're appending all files into a single table in Power Query. Power BI will then aggregate the calls correctly.