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 Sale...
  • 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




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