SUM X formula confusion

[Waseem]

Dear community

Somehow i am stuck up in a sumif type situation in power BI. My screenshot is as under

I have highlighted two fields in yellow. Precisely, I want to sum the "BILLAMOUNT" by filtering the "Date" column for the respective date in each row. This means that for each row when the month is same, i should get same filteretd total.

Appreciate your help.

Regards 

[Zubair_Muhammad · Accepted solution]

Hi @Waseem

Try with this one

Test =
SUMX (
    FILTER ( Pre_Rev_PAYG, Pre_Rev_PAYG[Date] = EARLIER ( Pre_Rev_PAYG[Date] ) ),
    Pre_Rev_PAYG[BILLAMOUNT]
)