Forum Discussion
Solved
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 ...
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!
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!