subtracting net revenue with the year therefor - return blank

[Anonymous]

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!

[v-xicai]

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.

[Anonymous]

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?

[v-xicai]

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.