Append Calculated Tables (Not in Edit Query)

biancabarroso — Tue, 20 Mar 2018 13:09:16 GMT

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!

Re: Append Calculated Tables (Not in Edit Query)

Greg_Deckler — Tue, 20 Mar 2018 13:44:40 GMT

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

topic Append Calculated Tables (Not in Edit Query) in Report Server

Append Calculated Tables (Not in Edit Query)

Re: Append Calculated Tables (Not in Edit Query)