98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Top staff group by count for most recent period | Forum
Top staff group by count for most recent period | Forum
Resolved · Medium Priority · Version 365
Mon 19 Dec 2022, 17:44Delegate 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:38Trainer 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:40Trainer 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:44Delegate 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
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Stay Updated and Engage with the CommunityPower 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. |
