I attended yesterday’s DAX Masterclass session. I have two questions based on the content.
During the class, Sam added a column to the Sales table to demonstrate how to add a column to a table. The table was Total Costs (Quantity * Unit Cost). Later he deleted the column saying it wasn’t necessary because Quantity and Cost were on the Sales table and could be used to obtain the Total Costs. I noticed that Total Revenue (Quantity * Unit Price) was on the Sales table, also. Should Total Revenue been deleted, also?
I’ve observed several Edna training classes and showcases, and downloaded the PBIX files for several of them. I’ve noticed that in some instances, Unit Price and Unit Cost reside on the Products table, in other cases they reside on the Sales table. Is there any reason for the difference? Froma Best Practices perspective, that is.