Merging two table

[Anonymous]

Hello Everyone, 

I would be glad if you could help me with the following issue :

I have two tables for which I built two Dax measures :

Table 1 :

[Date]                [Robot]            [Total]

01/01/2021       IDN                  300

01/01/2021       ABD                 400

01/01/2021        R3D                500

01/02/2021        F3D                 600

My first Dax measure is the total calculated

Table 2 :

[Date]                [Robot]            [Total]

01/01/2021       BOP 1              300

01/02/2021       BOP 2              400

01/03/2021       BOP 3              500

My second Dax measure is the total calculated

I would then like to consolidate both calcul to add up 1st DAX measure and 2nd DAX measure and calcul it depending on the month (not the day due to cardinality). How can I do it ? should I consider building a third table and merge table 1 and 2 data ? 

[selimovd]

Hey @Anonymous ,

you can do that in the measure if you just need it for a few calculations:

Sum both Tables = 
VAR vUnionTable = UNION('Table 1', 'Table 2')
RETURN
    SUMX(vUnionTable, 'Table 1'[Total])

Otherwise you can also create a real table with the UNION function as a DAX table.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[arvindsingh802 · Accepted solution]

Considering the table data and column, appending data in one table will be best, and you will be only needing one measure (Total Calculated)

If you want to keep these tables saperate and also wasnt to keep existing measures for some use

You can create a new measure where you can add up both measures
Measure3 = Measure1 + Measure2

[Anonymous]

Thanks for your help,

However I would like to add a filter on specific dates, which I think it is not possible.

For example, I want to have the total for January (both table have different dimensions : Table 1 Days/months and Table 2 months)

Best regards,

[arvindsingh802]

As both column format is Date so it will not be an issue
Considering the sample data you shared, if you selected Jan in slicer then total will be 1500 (Sum for IDN, ABD, R3D & BOP 1)