Forum Discussion

Jinji's avatar
Jinji
Frequent Visitor
10 years ago
Solved

Calculate with multiple tables

I have 2 Price Lists for 2015 and 2016.   2015 Price   2016 Price Product Price   Product Price Pen 5   Pen 6 Note 10   Note 10 Mouse 100   Keyboard 150     I...
  • anithat's avatar
    anithat
    10 years ago

    Hi Jinji

     

    Go to Edit Queries

     

    Click on the table in which you want to add new column.

     

    Click on "Add column" on Tool bar

     

    Add custom column with name 'Price UP' and write the logic as  (2016 Price - 2015 Price)

     

    Go to File > Apply & Close

     

    Thus your changes are saved.

     

     

  • GilesWalker's avatar
    GilesWalker
    10 years ago

    Jinji - had a quick play with it as the totals werent adding up. You can do a merge of the tables using a full outer join through query editor. Then add this conditional column

     

     

    Then I renamed some columns and deleted some and added a custom column:

     

     

    This then calculates the total difference properl

Baskar's avatar
Baskar
Resident Rockstar
10 years ago

Hey Jinji,

 

1. Create new measure from DAX

 

Different 2015-2016 =

if( isblank(sum('2015'[Price])) || sum('2015'[Price]) = 0,

Sum('2016'[Price]),

Sum('2016'[Price])-Sum('2015'[Price]))

 

2. From Power Query

 

In Query Editor window Merge these two Tables,

Then Add new column . there u can do the Calculation eg.(2016[price) - 2015(Price))

 

Before that  please replace the "NULL" with 0 .    in Price field.

 

 

Let check it .....