How do I make a new column from two different tables?

Question

How do I create a new table?. The table will be made by subtracting two columns from two different tables?. These are the two tables I am trying to subtract:&nbsp; Any help is appreciated.&nbsp;

amitchandak · Answer

HamidBee , You need to have common dimensions like Attributes and can have measure like and analyze against common dimensions
&nbsp;
Sum(2020[value]) -sum(2021[value])

hamidbee · Answer

They should have the same months and values if one was to analyze it row by row. Is that what you mean by common dimensions? Also is there a specific DAX code that is used for subtracting columns like this.

amitchandak · Answer

HamidBee , You have a calendar table, In that, you should have a month (without year) to compare against month
&nbsp;
You should prefer measure to subtract data across two tables
&nbsp;
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&amp;list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&amp;index=19

hamidbee · Answer

I was thinking to do a measure. But I really would like the difference to be inside a table because I plan to create a colour field. If I can get this calculcation onto a table it would make things alot simpler for me long term. Should I make a measure then put the measure into a table seperated by months.&nbsp;

anonymous · Answer

Hi&nbsp;HamidBee&nbsp;,
&nbsp;
Can you provide some dummy data?
&nbsp;
If it is the following data.

&nbsp;
Here's the solution.
1.Create a month column in both tables.
Month = FORMAT([Dates],"MMM")

&nbsp;
2.Create a measure.
Difference = 
VAR _20 =
    SUM ( '2020'[Value] )
VAR _21 =
    CALCULATE (
        SUM ( '2021'[Value] ),
        FILTER (
            '2021',
            [Attribute] = MAX ( '2020'[Attribute] )
                &amp;&amp; [Month] = MAX ( '2020'[Month] )
        )
    )
RETURN
    _20 - _21

&nbsp;
3.Results.

&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

How do I make a new column from two different tables?

5 Replies

Related content

How to add two different calculated columns of two different table

1. How to add two different calculated columns of two different table

Date difference between two different tables columns

Create a Column where sum two columns from different tables

Compare two columns in different tables