Forum Discussion

rhborders's avatar
rhborders
Helper I
8 years ago
Solved

Columns not aligning unless aggregated

I am trying to put a column in my table that has a 1:1 relationship between its query and the query that houses the other columns in my table. Whenever I put the column in it does a complete table jo...
Need Help
  • rhborders's avatar
    rhborders
    8 years ago

    My desired output was to have the CustProdRep column and the Expected revenue column to be populated in both columns of row. The only way I was able to do this was by aggregating one of the columns by appling a function such as sum or count. I ended up resolving this issue by writing a SQL statement that did what I wanted so nothing had to be done in BI. 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi rhborders,

 

I waas not clear about your problem. What do you mean "Align"? From above two images, it looks like that column [Expected Revenue] in both of them are align (the diplayed position?). What is your desired output?

 

Regards,

Yuliana Gu

rhborders's avatar
rhborders
Helper I
8 years ago

My desired output was to have the CustProdRep column and the Expected revenue column to be populated in both columns of row. The only way I was able to do this was by aggregating one of the columns by appling a function such as sum or count. I ended up resolving this issue by writing a SQL statement that did what I wanted so nothing had to be done in BI.