Forum Discussion

adavid999's avatar
adavid999
Icon for Helper V rankHelper V
5 years ago
Solved

tables append or union?

Hello,   I have several tables with identical fields. So far I have been loading and then appending the tables and then writing/applying my measures (rather than writing the same set of measures fo...
append
tables
  • AlB's avatar
    AlB
    5 years ago

    Hi adavid999 

    What you're doing sounds good.  Append the tables in Power Query, so that you have everything consolidated in one table and you can have your measure operate in just one table. If it's tables with the same columns as you describe it doesn't make sense to operate on them separately

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi adavid999 

What you're doing sounds good.  Append the tables in Power Query, so that you have everything consolidated in one table and you can have your measure operate in just one table. If it's tables with the same columns as you describe it doesn't make sense to operate on them separately

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers