Forum Discussion
Arioli_Chezhian
Helper II
Helper IIDynamic "IF" condition for calculated column
Hello everyone, I have a requirement to create a calculated column or Measure to achieve the below mentioned requirement. If Role 1 has the training T1 it should not be repeated for other Rol...
pls try this
Required Output = VAR _rx = RANKX('Table',[Name],,ASC,Dense) VAR _Result = RANKX('Table',[Trainings],,ASC,Dense) RETURN IF(_Result=_rx,[Trainings])
Ahmedx
Super User
Super Userpls try this
Required Output =
VAR _rx = RANKX('Table',[Name],,ASC,Dense)
VAR _Result = RANKX('Table',[Trainings],,ASC,Dense)
RETURN
IF(_Result=_rx,[Trainings])
Arioli_ChezhianAhmedx - Thank you for sharing this result.
- Ahmedx
If this post helps, then please consider accepting it as the solution to help other members find it faster.