Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @parry2k ,
Sure, let me organize a file free of confidential data and i'll upload it here again.
Thanks.
@Anonymous Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |