Formula help

[unnijoy]

I have Month, Week and count of new hire . We are entering this data on ever week. I need a formula that will calculate the total newhire for a month or multiple month. The formul should calulate the headcount of last week of the month. If am selecting multiple month it should calculate the headocunt of last week of ever month.

Month	Week	0-30
June	1	1
June	1	2
June	3	1
June	3	4
July	1	5
July	3	2
July	3	4
July	4	4
July	4	4
July	4	5

The formula should give June HC=5(Sume of June week 3), July as 13 (Sume of July week 4and if am selecting June and July it shoud give 18 ( Sume of June week 3 and July week 4)

[Zubair_Muhammad · Accepted solution]

@unnijoy

If you want the output in a card visual....you can use this

Measure =
CALCULATE (
    SUM ( Table1[0-30] ),
    GENERATE (
        VALUES ( Table1[Month] ),
        CALCULATETABLE (
            TOPN ( 1, SUMMARIZE ( Table1, [Week], [0-30] ), [Week], DESC )
        )
    )
)

[unnijoy]

@Zubair_Muhammad thanks a lot. It is working.