Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Command to merge multiple Columns into One column

Hi, Lets picture a table structure as this: Month        Budget_Q1       Budget_Q2     Budget_Q3       Budget_Q4 ---------------------------------------------------------------------------- Jan  ...
DAX
Dax Join
Merge
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi there.

 

Mate, DAX is not a tool for reshaping data. It's a CALCULATION tool only. To do what you want is a job for Power Query. If you want to have an easy time with Power BI, please learn to use the right tool for the job.

 

Also, I'd advise you to use the Unpivot tool from the ribbon of PQ instead of following the convoluted advice from HotChilli. If you use Unpivot, you won't have to type a single character.

 

Best

Darek

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Mate Anonymous ,

 

Thanks for clarifying. You are right. DAX is not the right tool for reshaping the data. 

It never hurts asking and exploring other solutions though. You just confirmed it. #thewayswelearn

 

I ended up reshaping my data in PQ using M on a row level basis.

 

Also thanks to HotChilli for the attempt to answer the question. 

 

I appreciate that.

 

Cheers,

Usher