calculated tables using Addcolumns and relatable

[Raju991]

i'm just taken this course and not able to solve this below question. can someone help me to solve this below request.

Create a calculated table.
Create a new calculated table called Yearly Sales by Color that contains the following data: 

All data from the Sales table, 

All Product Colordata from the Product table, 

And all Yearly values from the Date table.

Note down the total number of columns in the table.

Tip: Create the calculated table using the ADDCOLUMNS and RELATED DAX functions.

[MalkhazTsagarel · Accepted solution]

Hello,
You may use this code:
Yearly Sales by Color =
ADDCOLUMNS(
Sales,
"ProductColor", RELATED(Product[Color]),
"Year", YEAR(RELATED(Date[Date]))
). 
If it is your answer, please mark this as a solution