I’m going through a Coursera course and they’re asking to add a calculated table based on different columns from other tables (Step 3 in the attached image).
They propose the DAX solution attached which is giving the mentioned error. All screenshots are added which include the current model, task instructions, provided solution. I do see that there is no relationship between the Date table and the Sales table as there is no common column between the two tables. Not sure in the final result how they’re getting the year which I’m assuming from the orderDate column in the Sales table and how is the Date table related here.
2
Added the relationship between the Date and Sales tables.