DAX

[jananagarajan]

IF [Temp]= { Fixed [Customer ID]: MAX([Temp])} THEN Value END

This is written in Tableau LOD and I would like to write the same in DAX.

Data is attached

Customer ID	Temp	Value
T02	27	52
T03	35	62
T06	27	56
T01	27	60
T04	30	60
T05	26	58
T01	34	59
T02	35	51
T03	32	54
T01	30	53
T05	31	63
T01	35	59
T02	29	53
T06	32	53
T04	30	54
T05	27	65
T02	28	65
T01	35	58
T03	27	54
T02	30	51

[v-jingzhang · Accepted solution]

Hi @jananagarajan 

You can add a new column with below DAX. 

Value lof Max Temp = 
IF (
    'Table'[Temp]
        = CALCULATE ( MAX ( 'Table'[Temp] ), ALLEXCEPT ( 'Table', 'Table'[Customer ID] ) ),
    'Table'[Value]
)

Is this what you want? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[parry2k]

@jananagarajan can you provide the detail what Tableau formula is doing or provide the details on the expected output. 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.