Power BI: How to Show Headcount Data 👨‍👦‍👦 for Latest Month 📅(Question & Answer)

[@PowerBIPro]

👉 Do you have a Power BI Question? Just post a comment below. 👉 Or Read here how you can get all your Power BI Questions Answered: www.learnpowerbi.com/question 👉 Join our LIVE Events (including Power BI Q&A). Visit www.TalkPowerBI.com

[@sapnaa6576]

Showing the wrong measure first and then fixing it. That is an awesome way to teach. Because this happens in reality and we need to know how to debug.

[@jaeward7415]

Hi this is useful however what if you only have start dates and end dates? And need to able to filter by org, department and teams? I don’t have a report which is already counting the headcount for me

[@shoryaarora1464]

Indeed, I learned something new today. Thank you

[@maicon007]

THANK YOU!

[@ImranHussain-xv4se]

Learning slot from your video and your book Thanks for your help

[@PowerBIPro]

Great to hear!

[@jr713121]

Another Excelent video! Thanks For sharing! I have a question and I hope you can help me. To calculate turnover and headcount I linked my calendar table to my main table by deactivate the relationships and then activate them using the USERELATIONSHIP function. That part is working fine. However, Now I am calculating hire retention in a granular way during a 3-month period. I can say for each new hire, if they remain in the company after 3 months, but I had to use a different calendar. How can I use just one calendar table to calculate this and also turnover, headcount and all the other metrics? I have tried everything but can't find a solution different than two use two different calendars

[@kirillperian]

Hi, Avi! Thanks for the video! I noticed you took off the totals from the table visuals. What if you have a card visual where you want to show the Latest Headcount? Obviously, in the card visual, the year is not specified, but how can you "force" it to show the latest year's headcount when the filter context is above the Year?

[@PowerBIPro]

OMG! Kirill! How are you mate? Yup, the card visual would definitely work. See screenshot www.screencast.com/t/1rwm7eMQZ Power On! /Avi

[@kirillperian]

Thanks, Avi! I can't complain! Talk soon! 🤜🤛💪

[@lionelnguellot4580]

Hello, Thanks for video. I now only have the issue that for the running year I get 0 as the value stop at the current month and the max yearmonth is december 2024

[@sridrigger]

This is Cool, How to Calculate Open HC & Close HC for Year or Month. Stuck with Annual Attrition Calculation. ANy leads

[@vinipowerbi]

While using maps it shows blank screen. I'm unable to use maps please guide. I'm begginer at this. I have checked the settings they are ok.

[@PowerBIPro]

Hey Vinny, Avi here. Sorry to hear you are having trouble with Maps in Power BI. I created a quick video for you showing how I use Maps in Power BI. Check it out kzbin.infoBBt5w3mWpYg Also check out my Power BI Tutorial specifically designed for Beginners: kzbin.info/www/bejne/d3jVnWB-bZyjiLc And join me for our Live Q&A events at www.TalkPowerBI.com Power On! / Avi