Forum Discussion
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 - 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])
)