I have calculated the Sales margin value as below.
cog = Cost of goods sold
Tcost = Total cost
I also want to calculate sales margin %. What would be the right query to achieve sales margin %?
Go to Solution.
@AbbasG , Try like
Sales Margin %= divide(SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]), SUM('Total Sales'[Total Sales Amount]) ) )
View solution in original post
@amitchandak thank you so much Amit.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!