Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Type | 2012 | 2013 | 2014 | 2015 |
A | 1 | 2 | 3 | 4 |
B | 5 | 6 | 7 | 8 |
C | 9 | 10 | 11 | 12 |
And I'd like it like this:
Type | Year | Value |
A | 2012 | 1 |
A | 2013 | 2 |
A | 2014 | 3 |
A | 2015 | 4 |
B | 2012 | 5 |
B | 2013 | 6 |
B | 2014 | 7 |
B | 2015 | 8 |
C | 2012 | 9 |
C | 2013 | 10 |
C | 2014 | 11 |
C | 2015 | 12 |
Thanks in advance!
Solved! Go to Solution.
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.
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.
This is a much simpler way to accomplish what I was trying to.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |