cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tjlong84 Frequent Visitor
Frequent Visitor

Using concatenate inside a column reference

Is there a way to use a concatenation inside of a column reference?  Specifically I have a table where I would like to evaluate the formula created by CONCATENATE("RELATED(FAF44_HiLoForecasts[value_",CONCATENATE('Table'[Year],"])"))

 

I would like to do this because I have a large dataset that is matrixed and I would like to un-matrix it to make it more usable.

 

The data I have is set up like this:

Type2012201320142015
A1234
B5678
C9101112

 

And I'd like it like this:

TypeYearValue
A20121
A20132
A20143
A20154
B20125
B20136
B20147
B20158
C20129
C201310
C201411
C201512

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
mattbrice Senior Member
Senior Member

Re: Using concatenate inside a column reference

I know this is not a direct answer to the question you asked, but for this you are probably better off using Power Query to "Unpivot Columns" before pushing the data into the model.

 

2017-09-22_11-46-31.gif

2 REPLIES 2
mattbrice Senior Member
Senior Member

Re: Using concatenate inside a column reference

I know this is not a direct answer to the question you asked, but for this you are probably better off using Power Query to "Unpivot Columns" before pushing the data into the model.

 

2017-09-22_11-46-31.gif

tjlong84 Frequent Visitor
Frequent Visitor

Re: Using concatenate inside a column reference

This is a much simpler way to accomplish what I was trying to.

 

Thanks!