Creating a new column that counts rows per month data from a different tables

Chamari Normalize date formats in all tables to a common Year-Month format.
Aggregate the RE and REL tables by month.
Join these aggregates to your Call Volumes table.
Calculate per 1000 calls metrics.

 

Power Query Steps (recommended for date normalization):

In each table, add a new column for Year-Month:
Go to "Add Column" → "Custom Column" and use:

= Date.ToText([DateColumn], "yyyy-MM")

Replace [DateColumn] with the actual date field in each table.

 

Assuming your tables are named CallVolumes, RE, and REL, and all have a YearMonth column:

-- Count RE per month
Count RE =
CALCULATE(
COUNTROWS(RE),
RE[YearMonth] = CallVolumes[YearMonth]
)

-- Count REL per month
Count REL =
CALCULATE(
COUNTROWS(REL),
REL[YearMonth] = CallVolumes[YearMonth]
)

-- REs per 1000 Calls
REs per 1000 Calls =
DIVIDE([Count RE], CallVolumes[No. Calls]) * 1000

-- RELs per 1000 Calls
RELs per 1000 Calls =
DIVIDE([Count REL], CallVolumes[No. Calls]) * 1000

Hi Chamari,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you bhanu_gautam and kushanNa for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa