Forum Discussion

bradc's avatar
bradc
Frequent Visitor
1 year ago
Solved

Calculate Filters

Hi All,   I'm really struggling with Calculate and Filters.  I'm sure this is easy, but the solution is eluding me.   Basically I need to find the MAX Item number with a date, where the condition...
Need Help
  • bradc's avatar
    bradc
    1 year ago

    I cracked the code!

    This is what I needed:

    CALCULATE(
    MAX(Table[Date]),
    FILTER(
        'Table',
        Table[Condition] = FALSE && Table[Item] = EARLIER(Table[Item])
    )
)

    Thank you both sevenhills and danextian  for your assistance. 

    It is much apprecited.

bradc's avatar
bradc
Frequent Visitor
1 year ago

I cracked the code!

This is what I needed:

CALCULATE(
    MAX(Table[Date]),
    FILTER(
        'Table',
        Table[Condition] = FALSE && Table[Item] = EARLIER(Table[Item])
    )
)

Thank you both sevenhills and danextian  for your assistance. 

It is much apprecited.