Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
adavid999
Helper V
Helper V

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

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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 

 

SU18_powerbi_badge

 

View solution in original post

4 REPLIES 4
adavid999
Helper V
Helper V

thanks @Fowmy and @AlB good to know I am on the right track

Fowmy
Super User
Super User

@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 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

@Fowmy 

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?

AlB
Super User
Super User

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 

 

SU18_powerbi_badge

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.