cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nmck86 Member
Member

2 Calculated Tables merged into 1 table

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: 2 Calculated Tables merged into 1 table

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


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

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: 2 Calculated Tables merged into 1 table

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


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

Proud to be a Datanaut!