Forum Discussion

jimbolya's avatar
jimbolya
Regular Visitor
8 years ago
Solved

Merging Tables with Addition Function

I have two tables. They both have two columns. A category column and then a count for that category.   Example: Table #1 Column 1      Column 2 Abuse            45   Table #2 Column 1      Co...
Need Help
Tips and Tricks
  • anandav's avatar
    anandav
    8 years ago

    jimbolya,

     

    Try appending the two tables.

    Go to Home - Edit Queries - Append Queries - Append Queries as New.

     

    If you add the Colum 1 and Column 2 to a Table visual, it should display the summarised values.

     

    If you need to create a data table of the summarised values, you can use the SUMMARIZE() DAX function.

     

    If this solves your problem please mark as teh solution.

anandav's avatar
anandav
Skilled Sharer
8 years ago

jimbolya,

 

Try appending the two tables.

Go to Home - Edit Queries - Append Queries - Append Queries as New.

 

If you add the Colum 1 and Column 2 to a Table visual, it should display the summarised values.

 

If you need to create a data table of the summarised values, you can use the SUMMARIZE() DAX function.

 

If this solves your problem please mark as teh solution.

  • jimbolya's avatar
    jimbolya
    Regular Visitor
    8 years ago

    I will try this.  

    However, I've never used the SUMARIZE DAX function...

    That part will probaby not go well lol. 

     

    Jimbo