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
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
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
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
