Forum Discussion
Help Creating Gross Profit Measure
I am in a bit of a situation where I am stuck trying to calculate Gross Profit. My Table isn't broken out to an ideal scenario, thus I am relying on some DAX to get this solved. CATEGORY is the D...
Use the calculate function to create a measure like
Calculate(Sales - Cost of sales, Category = Sales)
Or you can breakout the column into 3 new columns and then build a measure to calculate the values.
Can you email a sample of your data?
I can work on it later in the day.
Hello,
This message went to spam so I am just seeing it. However I got it to work!