Calculate measure with If Statement

[vwiles84]

I am trying to write a calculation that if the Year is 2023 and the months are March and April, don't include those numbers in the sum.  If have the filter working for the month but need to include code to only exclude the month if it is a particular year (2023).  Can you assist? 

Here is the measure to exlude the 2 months. I just need to be able to only exclude these months IF it's 2023. I can't quite get it. 

Donation QTY Minus MarApril = CALCULATE(SUM(RPT_ITM_D[F64]),FILTER(RPT_ITM_D,RPT_ITM_D[F1034]=3), FILTER('Date Table', 'Date Table'[Month Name] <> "April"), FILTER('Date Table', 'Date Table'[Month Name] <> "March"))

[Anonymous · Accepted solution]

Hi @vwiles84 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Donation QTY Minus MarApril = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        'Table'[Year] <> 2023 || ('Table'[Month]<> "April" && 'Table'[Month]<>"March")
    )
)

Final output

Best regards,

Albert He

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

[JamesFR06]

Hi,

First of all store the year value on a vairable

Var ActivYear=selectedvalue(date(year)

var DonationQty=CALCULATE(SUM(RPT_ITM_D[F64]),RPT_ITM_D[F1034]=3)

var result= If(ActivYear=2023,

calculate(DonationQty,NOT ('Date Table'[Month Name]  in {"April","March"}),

DonationQty)

Return

result