Top staff group by count for most recent period | Forum

Resolved · Medium Priority · Version 365

Mon 19 Dec 2022, 17:44 Delegate Matt said...

Matt has attended:
No courses

Top staff group by count for most recent period

Hi Jens

I want to show the top staff group by count in the most recent month in a narrative box, am I right in thinking that something like this is the right direction? Can you help add in the clause about most recent time period please?

CONCATENATEX (TOPN ( 1, VALUES(AHR_Workforce[Staff Group - Top Level]), [FTEs]), AHR_Workforce[Staff Group - Top Level],";")

Thanks
Matt

Thu 22 Dec 2022, 14:38 Trainer Marius said...

RE: Top staff group by count for most recent period

Hi Matt,

Thank you for your question. Unfortunately, all our trainers able to answer your question are on leave until the new year.

Kind regards
Marius Barnard
STL

Mon 2 Jan 2023, 18:40 Trainer Jens said...

RE: Top staff group by count for most recent period

Hi Matt,

Happy New Year.

You will have to use time intelligence to filter by most recent month.

CALCULATE (
Count ( "what you want to count"),
FILTER ( "table name", MONTH ( "Date Column" ) = MONTH ( TODAY () - 1 ) )

I hope this make sense

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 3 Jan 2023, 10:44 Delegate Matt said...

RE: Top staff group by count for most recent period

Hi Jens,

Happy new year!

I can't get that working I'm afraid.

The most recent time period will always be Max(Reporting Quarter).

CONCATENATEX (TOPN ( 1, VALUES(BHR_Workforce[Staff Group - Top Level]), [FTEs]), BHR_Workforce[Staff Group - Top Level],";") FILTER (max('BHR_Workforce'[Reporting Quarter])

What do i need to change?

I think we will be booking another course with you solely about narrative DAX creation!

Thanks
Matt

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Stay Updated and Engage with the Community

Power BI is continually evolving, with new features and updates being released regularly. Stay informed about the latest enhancements by regularly checking the Power BI blog and community forums. Engaging with the Power BI community provides opportunities to learn from others, share your experiences, and get insights into best practices.

View all Power BI hints and tips