Forum Discussion

vwiles84's avatar
vwiles84
Icon for Helper III rankHelper III
2 years ago
Solved

Calculate measure with If Statement

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"))
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • JamesFR06's avatar
    JamesFR06
    Icon for Resolver IV rankResolver IV
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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