Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Duplicate values while merging columns

Hi all!   I have a Forecast table with Company/ Product/ Forecast columns:     I have another table with Product/ Sales but NO Company:     If I try to merge the Sales into the Fo...
Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

     

     

    Hi alicia_mtz,

     

    I've prepared the same result you are requesting by adding the company field in the sales table which stated "Nike" for all the rows, and by appending the sales table with the forecast table. I just used the PQ ribbons which produced the following M codes as I am not that conversant with M.  

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DataNinja777 

 

I've copied your line of code but it still gives me the same result, not your result, I don't know why 😞

 

 

Thanks

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi alicia_mtz,

 

Looking at your file, I think your source table for the sales still do not contain the company field which two "Nike" rows, therefore, it is showing null the top two lines.  What I did was to assign "Nike" in the source data for the sales table, in the additional row created with the name "Company", so that forecast table and sales table can be just apended. If you have any problem, please feel free to attach here your pbix file.  I will be able to fix it for you.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Got it now! Thank you! 🙂