Forum Discussion
Showing two columns on same line?
I have a table with image urls representing a before and after image that looks like this:
| ID | Before | After |
| 102 | http://abcd | |
| 198 | http://wldm | |
| 265 | http://fkldn | |
| 265 | http://dkdlc | |
| 102 | http://wwdc | |
| 198 | http://slddkf |
When I create a table to display the information I want the before and after image to be on the same line, not different lines. The before and after are calculated measures columns. How would I combine this into one "line" in a table?
Here is what it looks like now:
Thanks for any assistance!
Regards,
JingSpat
I was approaching this the wrong way. In the end I duplicated the table and then pivoted the columns to get the data I need. Thanks!
4 Replies
- vanessafvg
Community Champion
Jingspat what is your code for the measures?
After Image = if('GSC Data'[task_type]= "Task::Picture", IF('GSC Data'[task_title]="FCC After Picture",SUBSTITUTE(SUBSTITUTE('GSC Data'[value_array],"{",""),"}",""),BLANK()),BLANK())
Before Image = if('GSC Data'[task_type]= "Task::Picture", IF('GSC Data'[task_title]="FCC Before Picture",SUBSTITUTE(SUBSTITUTE('GSC Data'[value_array],"{",""),"}",""),BLANK()),BLANK())
Those measures are essentially converting a one item array to a useable URL.
I also said they were measures in the original post, but I just updated that to calculated columns, sorry for the confusion!
