ConcatenteX Formula Error

[Anonymous]

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 - which might help Solved: Re: ConcenateX new measure - cannot get the date t... - Microsoft Power BI Community

Period	Hit	Result
Q1	1	1
Q2	0	01
Q3	0	001
Q4	0	0001

Sample Date

Period	Hit	Last char of Period	Index
Q1	0	1	1
Q1	0	1	2
Q1	0	1	3
Q1	1	1	4
Q2	0	2	5
Q2	0	2	6
Q2	0	2	7
Q2	0	2	8
Q3	0	3	9
Q3	0	3	10
Q3	0	3	11
Q3	0	3	12
Q4	0	4	13
Q4	0	4	14
Q4	0	4	15
Q4	0	4	16

Measure

M =

LEFT(CONCATENATEX ( ALL ( '12 | Targets Table (2)' ), MAX('12 | Targets Table (2)'[Hit]),"") ,

SELECTEDVALUE ('12 | Targets Table (2)'[Last Characters])

)

[Anonymous · Accepted solution]

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.