Forum Discussion
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...
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.
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.