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
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Could you tell me if your problem has been solved by themistoklis 's suggestion? If it is, kindly Accept it as the solution to make this thread closed. More people will benefit from it. Or you are still confused about it, please show me your expected output.

 

Best Regards,
Eyelyn Qin