ORDER BY ASC OR DESC REQUIRED FOR A CALCULATION

[srkase]

Hi

The below is one of my dax .. I am calculating YOY growth in the calculation...

I always wanted to sort my results based on current year YOY%... 

YoYVal% =

VAR _currentyearvalue = [totval]

VAR _currentyear =

    MAX ( PROD_CABLE[YEAR] )

VAR _previousyear =

    MAXX ( FILTER ( ALL ( 'PROD_CABLE' ), 'PROD_CABLE'[YEAR] < _currentyear ), 'PROD_CABLE'[YEAR] )

VAR _previousyearvalue =

    CALCULATE ( [totval], 'PROD_CABLE'[YEAR] = _previousyear )

RETURN

    IF (

        _previousyearvalue && _currentyearvalue

            && HASONEVALUE ( 'PROD_CABLE'[YEAR] ),

        DIVIDE ( _currentyearvalue - _previousyearvalue, _previousyearvalue )

    )

how to add the sort option...

thanks in advance

Regards

SRK

[amitchandak]

@srkase , In power bi, You have to add a sort in visual. Not in measure unless you are creating rank or TOPn

also for YOY try measure like below with help from date table

//Only year vs Year, not a level below

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

or you can have

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.