- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 for each individual table).
Is this the most efficient/normal way to work with several tables? I.e. is this the norm or is there a more efficent way to to write measures that would say calculate a mean over several tables?
Thanks,
A
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@adavid999
The best method would be to combine the tables. You can combine all those tables onto a single table using either the APPEND option in Power Query or the UNION function in DAX.
Please refer to below article:
Append: https://docs.microsoft.com/en-us/power-query/append-queries
Union: https://docs.microsoft.com/en-us/dax/union-function-dax
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Between Append and Union which will take less time to load? I am currently using union and my model takes alot of time to refresh. If I switch to append will it be faster?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-15-2024 11:40 AM | |||
11-07-2024 03:33 PM | |||
01-06-2025 05:58 AM | |||
09-12-2024 05:49 AM | |||
12-04-2024 05:18 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |