Forum Discussion

johanthedataman's avatar
johanthedataman
Frequent Visitor
7 years ago
Solved

Max Value for 2 Filters

Hi there,   I have a question. I have the following dataset: ID Code OpportunityID Modified YearMonth StageID 142 SF000020 20 4/10/19 2019/04 5 106 SF000020 20 4/4/19 2019/0...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this calculated column formula

    =CALCULATE(MAX(Data[StageID]),FILTER(Data,Data[Code]=EARLIER(Data[Code])&&Data[YearMonth]=EARLIER(Data[YearMonth])))

    Hope this helps.

parry2k's avatar
parry2k
Super User
7 years ago

johanthedataman add new measure using following expression

 

Max Stage = 
CALCULATE( 
MAX( Table4[StageID] ),
 ALLEXCEPT( Table4, Table4[Code], Table4[YearMonth] ) 
)