Forum Discussion
DAX Calculated Column Order of Multiplying Difference Error
Dear Team, I have a table in the Power Pivot Data Model. I have created two Calculated Columns that are supposed to calculate the Line Item COGS for each sale. The two Formulas are identical, exc...
I have also tried this is Power BI. And the Calculated Columns yield different answers just by switching the order of how the numbers are multiplied:
#1 = Cost * Percentage * Units:
LineCOGS01 = ROUND(RELATED(dProducts[StandardCost])*fSales[PercentOfStandardCost]*fSales[Units],2)
#2 = Units * Percentage * Cost
#2 = Units * Percentage * Cost
LineCOGS02 = ROUND(fSales[Units]*fSales[PercentOfStandardCost]*RELATED(dProducts[StandardCost]),2)
Here is Power BI file: https://people.highline.edu/mgirvin/AllClasses/100/MultiplyingOrderError.pbix
Any ideas?
Here is Power BI file: https://people.highline.edu/mgirvin/AllClasses/100/MultiplyingOrderError.pbix
Any ideas?