How to get the count for specific month

[skidambi2]

Hello Gurus,

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 ?

[v-frfei-msft]

Hi @skidambi2,

We can create a measure as below.

currentmonthvalue = 
CALCULATE (
    SUM ( Table1[headcount] ),
    FILTER (
        ALL ( Table1 ),
        Table1[Yearmonth]
            = YEAR ( TODAY () ) * 100
                + MONTH ( TODAY () )
    )
)

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @skidambi2,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank