I have a table which contains the headcount of servicedesk .
I want to actually to get the count of headcount for a specific service desk for that month .
For example if you see the below screen shot the headcount for bogota is 1248 but for 10th Month its 77 . How do i get the current month count ?
We can create a measure as below.
SUM ( Table1[headcount] ),
ALL ( Table1 ),
= YEAR ( TODAY () ) * 100
+ MONTH ( TODAY () )
For more details, please check the pbix as attached.
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.