Sum of unique repeated values in each month with other months.

[Prabhu11]

Hi Community,

I am trying to find the sum of unique repeated Targets with other months. 

The following table is my data model

Date	Value
01-04-22	100
02-04-22	100
01-05-22	200
02-05-22	200
01-06-22	150

Here I need to sum only one Target of the months April, May & June 

The expected Output will be

100+200+150

Ans =450

Kindly help

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected output measure: = 
SUMX (
    SUMMARIZE (
        ADDCOLUMNS (
            Data,
            "@year-month",
                YEAR ( Data[Date] ) & "-"
                    & MONTH ( Data[Date] )
        ),
        [@year-month],
        Data[Value]
    ),
    Data[Value]
)

[Prabhu11]

Hi Jihwan,

Thanks for the quick response.

I agree with this solution however is there any alternative method to achieve the same? 

Regards

Prabhu

[Jihwan_Kim]

Hi,

Thank you very much for your feedback.

In my opinion, if you have relationships with other tables, and if you have a dim-calendar table, you can have much more options to create a solution.