Need Difference and Percentage Difference for random selected years

[avulasandeep]

Hi PowerBI Experts ,

i Need some dax formulas ,

Difference and Percentage Difference for Random Selected Years .

Suppose if i select years randomly like 2010 ,2012 ,2014, 2016

i need

1.Dax for Difference of sales  for 2010 and 2012 .....2012 and 2014 ......2014 and 2016

2.Dax for percentage difference for selected years

3.what percentage difference??????  if i select 10%  0r 20 % or 30%....what ever the percentage i select from the slicer i need that percentage sales only 

Is that Possible using Dax??? please help me out . here is screenshot

Thanks in Advance 

Thanks 

Sandeep

[v-jiascu-msft · Accepted solution]

Hi Sandeep,

Please try the measures below.

Measure1 =
VAR lastSelectedYear =
    CALCULATE (
        LASTNONBLANK ( Table1[Years], 1 ),
        FILTER ( ALLSELECTED ( Table1[Years] ), Table1[Years] < MIN ( Table1[Years] ) )
    )
VAR lastSelectedYearSales =
    CALCULATE (
        SUM ( Table1[Sales] ),
        FILTER ( ALL ( Table1[Years] ), Table1[Years] = lastSelectedYear )
    )
RETURN
    IF (
        ISBLANK ( lastSelectedYearSales ),
        BLANK (),
        SUM ( Table1[Sales] ) - lastSelectedYearSales
    )

Measure2 =
DIVIDE ( [Measure1], SUM ( Table1[Sales] ), 99999 )
//99999 means error here

Best Regards,