Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ConcatenteX Formula Error

Hi Experts   i am trying to get the following result as shown in the table below but can figure out how to use the max value with the concatenateX function..   Here is the previous question - whi...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Well, Here your Answer

    rank =
    LEFT (
    CONCATENATEX(ALL('Table (9)'),'Table (9)'[Hit]," ",'Table (9)'[Index]),
    SELECTEDVALUE ( 'Table (9)'[Index] ) * 2
    )



    If You got Answer Mark it as Solution and give Kudos.