Help needed with month total

[siros92]

Hi all, thanks for all previous help. Love this community. 

I've got a bit of an interesting one i'm hoping you guys can help me with. 

I've got a calculated colum displaying total month income per customer and because of the datastructure i've been forced into having it like that - I know it is not ideal... 

I'm now trying to make a calculated column for a month total based on the sales per month column. 

Below is a mock sheet with some data and what would be the desired outcome. the desired outcome is a sum by month of the uniqe value per customer. 

			desired outcome
date	Customer	Sales per month	Total sales month
03.01.2022	xx	150000	450000
02.01.2022	xx	150000	450000
01.01.2022	xx	150000	450000
03.01.2022	yy	200000	450000
02.01.2022	yy	200000	450000
01.01.2022	yy	200000	450000
03.01.2022	zz	100000	450000
02.01.2022	zz	100000	450000
03.02.2022	xx	50000	180000
02.02.2022	xx	50000	180000
01.02.2022	xx	50000	180000
03.02.2022	yy	100000	180000
02.02.2022	yy	100000	180000
01.02.2022	yy	100000	180000
03.02.2022	zz	30000	180000
02.02.2022	zz	30000	180000

in advance thanks for any help! 

[siros92]

Thank you very much, you my friend are a propper star! 

Again thank you as well for also taking the time to show it propperly it is greatly appreciated. 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated column.

Total sales month CC =
VAR _currentmonthend =
    EOMONTH ( Data[date], 0 )
VAR _uniquetablepermonth =
    SUMMARIZE (
        FILTER ( Data, EOMONTH ( Data[date], 0 ) = _currentmonthend ),
        Data[Customer],
        Data[Sales per month]
    )
RETURN
    SUMX ( _uniquetablepermonth, Data[Sales per month] )