Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional measure

Hello   I have a Measure like: Measure=MAX([Value])   For the data: Product,Value,Date A, 1, Date1 B, 2, Date1 A, 3, Date1   I want for every date, when Product=A to return MAX([Value]) an...
Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

    Anonymous 

     

    Try the following formula. Also attached a workspace.

     

    Column = If(Sheet1[Product] = "A",CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
),
CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
) /100
)
themistoklis's avatar
themistoklis
Community Champion
4 years ago

Anonymous 

 

Try the following formula. Also attached a workspace.

 

Column = If(Sheet1[Product] = "A",CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
),
CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
) /100
)