Forum Discussion
Showing two columns on same line?
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!
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!