Sales Percentage not working correctly

[dani_always]

Hello All,

My Sales % column is not calculating correctly as the numbers are all positive. Any suggestions are appreciated.

Thanks.

Previous Year Sales	Current Year Sales	Sales %
585749.19	370309.78	1.177270912
221761.2	167007.71	1.321801989
88842.86	88607.08	3.159434982

The DAX I'm using

Current Year Sales =

CALCULATE(

    SUM('SEC rptRevenueAll_V'[GrossSales]),

    FILTER(

        'SEC rptRevenueAll_V',

        YEAR('SEC rptRevenueAll_V'[ActivityMonth]) = YEAR(TODAY())

    )

)

Previous Year Sales =

CALCULATE(

    SUM('SEC rptRevenueAll_V'[GrossSales]),

    FILTER(

        'SEC rptRevenueAll_V',

        YEAR('SEC rptRevenueAll_V'[ActivityMonth]) = YEAR(TODAY()) - 1

    )

)

Sales % Difference =

DIVIDE(

    [Sales] - CALCULATE([Sales], SAMEPERIODLASTYEAR('SEC rptRevenueAll_V'[ActivityMonth])),

    CALCULATE([Sales], SAMEPERIODLASTYEAR('SEC rptRevenueAll_V'[ActivityMonth]))

)

[mh2587 · Accepted solution]

Sales % Difference = 
VAR CurrentYearSales = [Current Year Sales]
VAR PreviousYearSales = [Previous Year Sales]
VAR Difference = CurrentYearSales - PreviousYearSales
RETURN
IF(
    PreviousYearSales = 0,
    BLANK(),
    Difference / PreviousYearSales
)
//try this one might help you

[dani_always]

Thanks! That worked. I added a little below more to make it a whole number.

Sales % Difference =

VAR CurrentYearSales = [Current Year Sales]

VAR PreviousYearSales = [Previous Year Sales]

VAR Difference = CurrentYearSales - PreviousYearSales

RETURN

IF(

    PreviousYearSales = 0,

    BLANK(),

    ((Difference / PreviousYearSales) * 100)

)