Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exclude current month values via calculated column

Hello, I am trying to exclude values with the date = the last nonblank date & with the value_type = 'actuals'. I make this distinction because I am graphing Forecast vs Actuals , & forecast values go...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create calculated column like DAX below.

     

    Column1 =
VAR _MaxDate =
    CALCULATE (
        MAX ( Main[date] ),
        ALLEXCEPT ( Main, Main[product_name], Main[value_type] )
    )
RETURN
    IF ( Main[value_type] = "actuals" && Main[date] = _MaxDate, "Delete", BLANK () )

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

To add more information, when I use the second formula above for the calculated column, it incorrectly excludes all actuals values. When I'd like to just exclude only that month's values for actuals.