Calculate sum of specific months

[Alexandra_B]

Hello.

I need to calculate the following formula, but based on specific months (ie April to September 2021, 2022)

x = number + number + sum(data in a table). I think I need to use DATESINPERIOD. but I don`t know how to select the months.

I have a date table (01/01/2019 to present, I will need April to Sept 21 and 22)

How could I do it?

[v-yanjiang-msft · Accepted solution]

Hi @Alexandra_B ,

According to your description, I create a sample.

Here's my solution, create a measure.

X =
VAR _Sum =
    CALCULATE (
        SUM ( 'BB_EGLF_CDD_15 5C_till_june22'[CDD 15.5] ),
        FILTER (
            ALL ( 'BB_EGLF_CDD_15 5C_till_june22' ),
            MONTH ( 'BB_EGLF_CDD_15 5C_till_june22'[Month] )
                IN { 4, 5, 6, 7, 8, 9 }
                    && YEAR ( 'BB_EGLF_CDD_15 5C_till_june22'[Month] ) IN { 2019, 2020, 2021, 2022 }
        )
    )
RETURN
    42180.2942 + 68.8235277 * _Sum

Here I only return the sum and get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[Alexandra_B]

Thank you 🙂

[Anonymous]

@Alexandra_B Try this 

var a = calculate ( sum (data in table ) , DATESBETWEEN ( your date column , Start date , End date))
return number + number + a

[Alexandra_B]

Hello, @Anonymous .
Thank you for your reply.
I have tried, but I get the following error.

The syntax for 'return' is incorrect.
(DAX(CALCULATE (SUM( 'BB_EGLF_CDD_15 5C_till_june22'[CDD 15.5] ), DATESBETWEEN('BB_EGLF_CDD_15 5C_till_june22'[Month], DATE(2021,04,01), DATE(2021,09,30)))return "42180.2942" + "68.8235277" * 'a')).

I am doing it wrong?

[Anonymous]

Create a measure 
x = 
var a =CALCULATE (SUM( 'BB_EGLF_CDD_15 5C_till_june22'[CDD 15.5] ),
DATESBETWEEN('BB_EGLF_CDD_15 5C_till_june22'[Month],
DATE(2021,04,01),
DATE(2021,09,30))
return 42180.2942 + 68.8235277 * a

[Alexandra_B]

What if I need for all the years same months , 2019 - 2022? That means I cannot use DATESBETWEEN for it... 😞

[Anonymous]

yes correct, Datesbetween wont work there. 
can you show what exactly you are trying to achive.