Forum Discussion

generaluser's avatar
generaluser
Regular Visitor
9 years ago
Solved

Converting multiple columns into 1 column

Hi,   I would like to group multiple columns into one column. I have the product name in column A, and then the units by month in the columns after. I would like to keep column A as the product nam...
  • Sean's avatar
    Sean
    9 years ago

    In the Query Editor

    1) select the Product Column

    2) Transform tab - Unpivot Columns - Unpivot Other Columns

    3) Rename the Attribute and Values columns - Month and Units

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi. 

I have a similar situation. 

Column A Column Sales1   Column Sales 2    Sales Total 

BEN                 NULL                       400

LISA                 1000                        NULL

MEG                 2500                       NULL

 

I would like to have Total Sales - wather it is sum or not it doesnt matter, as the columns Sales1 and Sales2 are DAX(calculated) columns- I habe already sum from different tables. Any ideas on how i can make ONE column with the sales of each person=?

 

Thank you and looking forward. 

 

Related content