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 need to subtract the net revenue 2017 with the net revenu from 2016, but also with the same quarter.
I tried a code but it return nothing.
Many thanks for any help you can give me!
Hi @Anonymous ,
You can create measure like DAX below.
NetRevenue VS. Same Quarter Last Year =
VAR LastYear =
CALCULATE (
SUM ( Table1[NetRevenue] ),
FILTER (
ALLSELECTED ( Table1 ),
Table1[Month] = MAX ( Table1[Month] )
&& Table1[Year]
= MAX ( Table1[Year] ) - 1
)
)
RETURN
IF ( LastYear = BLANK (), BLANK (), MAX ( [NetRevenue] ) - LastYear )
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xicai ,
thanks for your reply!
I tried using your code and tweaking the values, but for some reason the result is still wrong.
My answer should be equal to -2.103.328,01 for quarter 4.
6.169.973,74 (net revenue 2017 Q 4)- 8.273.301,75 (net revenue 2016 Q 4) = -2.103.328,01.
The problem that I have now, is that the code works, but I have not the value that I was expected.
Am I missing something?
Hi @Anonymous ,
Assuming that there is a relationship between the table Sales and Dates on date field, you can try to change the field Dates[Month] to Dates[Quarter] in formula above.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |