Forum Discussion

Raju991's avatar
Raju991
New Member
2 years ago
Solved

calculated tables using Addcolumns and relatable

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's avatar
    MalkhazTsagarel
    2 years ago

    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




1 Reply

  • MalkhazTsagarel's avatar
    MalkhazTsagarel
    Regular Visitor
    2 years ago

    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