Forum Discussion

ahmadhlawa's avatar
ahmadhlawa
Regular Visitor
6 years ago

Load& Combine + Unpivot

hi Team,   i have monthly excel files that contains a forecast for some items, each item has a code and descrition. the table i recieve monthly contain first column called "code", second column ca...
Need Help
Show and Tell
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi ahmadhlawa ,

 

Have you checked the file ?

I've created this scenario with 3 files, when it doesn't have dates, it's null (can be replaced to 0).

ahmadhlawa's avatar
ahmadhlawa
Regular Visitor
6 years ago

camargos88  your file looks fine, but i don't have the sources on my PC, so can't trace the steps.

 

do you do those steps to the sample file (from your screen shot i can't see the "Source name" column)?

what i tried is, first i combine all files, then unpivot them, then put the functions you mentioned.

 

if you do it to the sample file can you please elaborate how can i do that?

    • ahmadhlawa's avatar
      ahmadhlawa
      Regular Visitor
      6 years ago

      camargos88  sorry for bothering alot but you are really helping.

      now i applied all the steps until pivoting on the sample file, when i click apply and close for the query, it gives me the error as "column "column3" of the table wasn't found"

      • camargos88's avatar
        camargos88
        Community Champion
        6 years ago

        ahmadhlawa ,

         

        I just refreshed the pbix without erros.

        Did you change something on the code or excel files ? If yes, maybe it needs some adjustments.