DAX calculation for Growth

DAX DAX Calculations
1

Good day all,

Need some guidance on a growth Calculation, i am using standard formula to calculate growth:

(TY Sales - LY Sales) / LY Sales

My issue comes when when last year had a negative value and this year has positive values. Result of this is Growth % becomes negative which is incorrect:

image

2

Hi @neilonbooysen,

Try something like this

Growth % =
VAR AbsLY =
    IF(
        [TY Sales] > 0 && [LY Sales] < 0,
        ABS( [LY Sales] ),
        [LY Sales]
    )
RETURN
     ( [TY Sales] - [LY Sales] ) / AbsLY
3

Thanks Melissa, this worked.

May i ask another question?

I have 20 tables,
a) i want to create a drop down with the table names in it
b) i want to use 1 table visual and when i select the table name from the drop down, the data in the visual should return that tables data.

hope that makes sense.

Neilon

4

Hi @neilonbooysen,

Your second question is unrelated to the first, please create a new topic for that and provide a mock up
Thanks!

5

apologies, will do so now.