cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biancabarroso
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!

1 REPLY 1
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.