Percentage Difference of Sales for Selected years only

[avulasandeep]

Hi all ,

Here is my Question again ,

i am getting year over year % Difference by using Quick measure or Dax calculations. But my question is , if I select years randomly from the slicers it is displaying on the previous year difference only not with the selected years as shown in below images.

everything i need is to calculate the year over year difference on the selected year from slicers , and if all years selected it has to display the previous year difference.

from above screenshot :

i need selected year over year percentage diff .

Anyone if you get the dax calculations for selected years with previous selected years percentage difference, Please let me know .

waiting......

Thanks 

sandeep 
9441181581

[ryan_mayu]

@avulasandeep

Please try the coding below to see if this can match your requirement. Thanks

test1 =

VAR MAXDATE=MAX(Sheet3[year])

VAR maxamount=CALCULATE([totalamount],FILTER(Sheet3,Sheet3[year]=MAXDATE))

VAR Secondmaxdate=MAXX(FILTER(ALLSELECTED(Sheet3),Sheet3[year]<MAXDATE),Sheet3[year])

VAR secondmaxamount=CALCULATE([totalamount],FILTER(ALLSELECTED(Sheet3),(Sheet3[year])=Secondmaxdate))

RETURN

if(ISBLANK(secondmaxamount)," ",DIVIDE(maxamount-secondmaxamount,secondmaxamount))

[Kristjan76]

Hi there,

I would try something like (I have not tried this):

total YoY% =
VAR currentYear = Dates[Year]
VAR preYear = 
  CALCULATE(
    MAX(Dates[Year]), 
    ALLSELECTED(Dates[Year]), 
    Dates[Year] < currentYear 
)
RETURN
[total] / CALCULATE(total; Dates[Year] = preYear) - 1

Regars,
Kristjan76

[avulasandeep]

@Kristjan76

This measure is not working fine , please let me know any another measure.

Thanks 

sandeep

[Kristjan76]

You are right it was not working, you can try this one:

total YoY% =
VAR currentYear = IF(HASONEVALUE(Dates[Year]),VALUES(Dates[Year]))
VAR yrs = ALLSELECTED(Dates[Year])
VAR preYear = 
  MAXX(
    FILTER(
      yrs, 
      Dates[Year] < currentYear
    ),
    Dates[Year]
)
VAR res = DIVIDE([total] , CALCULATE([total], Dates[Year] = preYear)
RETURN
IF(NOT(ISBLANK(res)), res - 1)

Regards,

Kristjan