Forum Discussion

PowerBiKing's avatar
PowerBiKing
Frequent Visitor
3 years ago
Solved

Add identifier column before appending queries

Hi,   I'm bringing a PDF into Power BI that contains 3 tables that I would like to append to create one "master" table. All of the columns match up, and I can append the data as needed with no issu...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi PowerBiKing ,

     

    I may be missing something here, but can't you just add a new custom column to each query with the calculation = "Source 1/2/3" ?

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi PowerBiKing ,

 

I may be missing something here, but can't you just add a new custom column to each query with the calculation = "Source 1/2/3" ?

 

Pete

PowerBiKing's avatar
PowerBiKing
Frequent Visitor
3 years ago

Ah yes thank you!

 

When I tried this earlier I couldn't get it to work (think I missed off the quotations) and I assumed that you couldn't just hard code it.