Get the first value of each month

[Anonymous]

Hi all, 

I have a card componant that show the credits available for each user by month. 

For exemple, each month, i have 8 credits allocated. But the available credits information are on a reservation table. It makes the allocated credit per month duplicated for each reservation. 

I would like to SUM the allocated credits into a Card componant by Month but with a distinct like the first row of each month. 

Here's an exemple of what i need. 

I would like to get only 1 value per month and sum it 

How can i do this ? 

Thanks 

[Anonymous]

@Anonymous Thanks for the summarize measure ! It works perfectly 

[Anonymous · Accepted solution]

@Anonymous , I believe this measure will do the trick:

Monthly Allocated Credits = 
    SUMX(
        SUMMARIZE(
            'YourTable'
            ,'YourTable'[Month]
            ,'YourTable'[Allocated Credit Per Month]
        )
        ,'YourTable'[Allocated Credit Per Month]
    )

[vapid128]

sumx(values([Month], calculate(max([Allocated credit per month]))