Showing results for 
Search instead for 
Did you mean: 
biancabarroso Frequent Visitor
Frequent Visitor

Append Calculated Tables (Not in Edit Query)

I am working with Data Quality Dashboards. In order to avoid doing my initial selection using Python before uploading the tables into Power BI (can be tricky for my end user when I hand things over), I am trying to do it all inside the tool. Therefore I create various CALCULATETABLE functions to spot the entries that are violating my business rules. Ultimately I want to have one OVERALL VIOLATIONS table.


The only function I know to append tables is UNION. However, it does not allow me to append more than two tables at a time. Consequently, I have to merge two at a time until everything becomes one main table. Do you happen to know a more effective way of doing this?


Thanks in advance!

Super User
Super User

Re: Append Calculated Tables (Not in Edit Query)

To the best of my knowledge, UNION is really the only function for this. There is no UNIONX function.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)