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.
Hi,
I have the following 3 measures built:
I added a column called "products "with the measures listed. I am having an issue where if the sales last year to date is negative and the sales current year to date is positive,
the sales % change measure is returning a negative number. That is inaccurate as we had more sales this year than last year. How can I fix that?
Solved! Go to Solution.
@ttaa4455 mathematic wise the result come out negative, yes :). But if you want to do something else here then you could wrap it with an if and add a different calculation to this scenario.
Somthing like:
IF( AND([SALES] >= 0 , [SALES LAST YEAR] >= 0, [STANDARD Y/Y MEASURE], [SOMETHING ELSE])
@ttaa4455 what result do you want to get for example?
This year: 10
Last year: -2
?
So let's say for
Product A we had the $500 in sales this year, but last year the sales was -400 (loss).
The sales percent change should be positive right? Because we got sales this year but not last year. But when I put my measure for sales % change it's negative change. Shouldn't it be positive?
I am dividing my sales this year by sales last year
@ttaa4455 mathematic wise the result come out negative, yes :). But if you want to do something else here then you could wrap it with an if and add a different calculation to this scenario.
Somthing like:
IF( AND([SALES] >= 0 , [SALES LAST YEAR] >= 0, [STANDARD Y/Y MEASURE], [SOMETHING ELSE])
So it looks like this: Sales % Chg = Divide([Sales CYTD],[Sales LYTD)-1
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |