Showing results for 
Search instead for 
Did you mean: 
jess11_11 Regular Visitor
Regular Visitor

Summing fortnightly granularity data into monthly

Hi all, 

I'm relatively new to Power BI and i'm a bit stuck on something. 

I have a report level date slicer that is on a fortnightly pay period selection. However, I want some of the data on that report to be shown at a monthly granularity. At the moment, the data is at a fortnightly granularity. 

I want to sum up all headcounts for the month in which the fortnightly period exists in. For example, if i select 15/04/19, i want it to sum up all the headcount for month of April 2019. 

So far i'm making a new colum and this is what i have: 


But surely there is a better way to do it. I also have to sum up headcount at a monthly level for age groups and this method doesn't seem to work.

For example, i have age groups: <20, 20-30, 30-40, 40-50, 50+ and i have the associated headcount next to it for each pay period fortnight. But i want to be able to sum up headcount for each age bucket monthly and show it on a bar chart. 

Thank you in advance. Really appreciate any help i can get. 

Super User
Super User

Re: Summing fortnightly granularity data into monthly

@jess11_11 Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.

Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.

jess11_11 Regular Visitor
Regular Visitor

Re: Summing fortnightly granularity data into monthly

Hi @parry2k ,

Sure, let me organize a file free of confidential data and i'll upload it here again. 


Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 43 members 1,158 guests
Please welcome our newest community members: