Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Driver
Thus, if CATEGORY = Sales then I need to subtract CATEGORY=COST OF SALES from CATEGORY= SALES.
Then, If CATEGORY = DIRECT EXPENSES subtract from Gross PROFIT.
Problem is how the data is stored. If someone could help that would be great.
Solved! Go to Solution.
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.
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.
Unfortunately, it's not that easy for this case. I am provided with the all the category is one column and need to imbed some kind of conditional logic to look for when the categories are met.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |