Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |