2 Calculated Tables merged into 1 table

[nmck86]

Hi,

I have 2 tables that were created using the below formula:

Employee Work County & State (for CyberGrants Data relationship) = CALCULATETABLE(DISTINCT('IRS Masterfile'[County and State]),'IRS Masterfile'[County and State] <> BLANK())

I want to merge those 2 tables; however, when I go to edit queries the 2 tables I created through the dax formulas are not present for merging... any ideas on how I can do this?

[MFelix · Accepted solution]

Hi @nmck86,

Try using the UNION formula check these pages below:

- https://msdn.microsoft.com/en-us/library/dn802530.aspx
- https://www.youtube.com/watch?v=QUJk6QLN05I

Regards,
MFelix