Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago
Solved

How do I create a new Table with two columns from two different tables (No measures)?

I am trying to create a new table which contains two columns. Column 1 will calculate the difference between Value 2021 and Value 2020. Column 2 will calculate the percentage change using value 2020 ...
Need Help
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, HamidBee 

    You don't need add a new table, you can directly add calculated columns to the table ‘2021’ as follows:

    Dates_1 = DATEADD('Calendar'[Date],-1,YEAR)
    Value_1 = LOOKUPVALUE('2020'[Value],'2020'[Dates],'2021'[Dates_1],'2020'[Attribute],'2021'[Attribute])
    Difference = '2021'[Value]-'2021'[Value_1]
    Percentage = IF('2021'[Value_1]=0,BLANK(),'2021'[Difference]/'2021'[Value_1])*100

    Result:

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago

I was really only hoping that the month would show as that is what I am comparing. Please see the answer I sent to "ebeery".

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, HamidBee 

You don't need add a new table, you can directly add calculated columns to the table ‘2021’ as follows:

Dates_1 = DATEADD('Calendar'[Date],-1,YEAR)
Value_1 = LOOKUPVALUE('2020'[Value],'2020'[Dates],'2021'[Dates_1],'2020'[Attribute],'2021'[Attribute])
Difference = '2021'[Value]-'2021'[Value_1]
Percentage = IF('2021'[Value_1]=0,BLANK(),'2021'[Difference]/'2021'[Value_1])*100

Result:

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.