I need a Dax expression to calculate the % profit in the attached doc.
Also how to get the negative values in a bracket. ex -2569856 (2569856)Any number in a bracket in the attached sheet is negative
To get the % Profit for each description.
Divide - Bikes/Product Line Profit * 100
17,507,002 / 105,216,979 *100 = 16.7%ThanksDJ
Revenue1 = FORMAT(Sheet1[Revenue],"#,##0.0;(#,##0.0)")