Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HotChilli 
Here is the excel and the output below.



As the file was also used among the team, so i was wondering if changes can be done within power bi itself or minimum change to excel.
Thank you for the advice.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi all

    Ashish_Mathur HotChilli 

    i was testing with another simple file as follow, but encounter same error also...any idea?

     

    • HotChilli's avatar
      HotChilli
      Community Champion
      6 years ago

      The second file is not in the same format as the one you posted earlier.

      The second one has a Merge column which contains the data from 2 columns in the first file, so that's why it's not working

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      My method should work.  Please retry.  I am travelling and therefore cannot try my method on your file right now.