https://community.fabric.microsoft.com/t5/Developer/Add-Columns-based-on-Data-in-separate-query/m-p/25806#M710 <P>Is there a way to create new columns in a query based on a separate data query?&nbsp; I would like to accomplish something&nbsp;similar to a pivot table where you can assign a data field as the columns and have the row values be determined by the column</P><P>&nbsp;</P> Wed, 30 Mar 2016 16:13:58 GMT kreese 2016-03-30T16:13:58Z https://community.fabric.microsoft.com/t5/Developer/Add-Columns-based-on-Data-in-separate-query/m-p/25806#M710 <P>Is there a way to create new columns in a query based on a separate data query?&nbsp; I would like to accomplish something&nbsp;similar to a pivot table where you can assign a data field as the columns and have the row values be determined by the column</P><P>&nbsp;</P> Wed, 30 Mar 2016 16:13:58 GMT https://community.fabric.microsoft.com/t5/Developer/Add-Columns-based-on-Data-in-separate-query/m-p/25806#M710 kreese 2016-03-30T16:13:58Z