Calculate total for month by customer

[Anonymous]

Hi,

I need to calculate the total per month by customer, and that sum needs to be used in a calculated column formula.

I have seen this post but when I use it, it looks like it's summing the entire table.

https://community.powerbi.com/t5/Desktop/Calculated-Column-of-Sum-per-Month/td-p/442402

Example data set below. I've done a quick mock of what the "Month Total for Customer" should look like.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may use DAX below.

Column =
SUMX (
    FILTER (
        Table1,
        Table1[customer] = EARLIER ( Table1[customer] )
            && DATEDIFF ( Table1[day], EARLIER ( Table1[day] ), MONTH ) = 0
    ),
    Table1[sales]
)