calculated tables using Addcolumns and relatable

Raju991 — Sun, 28 Jul 2024 17:58:57 GMT

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.

Re: calculated tables using Addcolumns and relatable

MalkhazTsagarel — Sun, 28 Jul 2024 18:26:03 GMT

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

topic Re: calculated tables using Addcolumns and relatable in DAX Commands and Tips

calculated tables using Addcolumns and relatable

Re: calculated tables using Addcolumns and relatable