Forum Discussion

ScorpionKing's avatar
ScorpionKing
Frequent Visitor
8 years ago

How to combine two columns from the same table

Hi everyone! Pls help me combine two columns from the same table as shown below.   Thanks in advance!  
Need Help
ScorpionKing's avatar
ScorpionKing
Frequent Visitor
8 years ago

Hi Zubair_Muhammad, appreciate your very fast reply. Is there a way not to label all my columns? I have 100 columns and 800k rows. Would there be an impact in the speed? Is there a way to do it in the Query table?

 

Thanks

 

 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI ScorpionKing

     

    In the above example you needed only 3 columns as output

     

    Do you need 100 columns as output and or only 3 out of 100?

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      ScorpionKing

       

      Using Query Editor,

       

      You can use the Append Queries to do the same Union I did using DAX

       

      Create a Duplicate Query and then append the Original Query to that Duplicate Query