Forum Discussion

jananagarajan's avatar
jananagarajan
Regular Visitor
3 years ago
Solved

DAX

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 2...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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's avatar
parry2k
Super User
3 years ago

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.