percent change on a percent column

[nleuck]

Is it possible to use a DAX function to get a measure that calculates the % change for each Store from year to year? I brought the table in from SQL Server Database. This is an example of what some of my data looks like. I formatted the %Compliant column after I brought it into Power BI.

Any help would be great. Thanks for your time.

Year          StoreID          Items Compliant          Total Items          %Compliant

2014          1                    10                                 15                        66.67%

2014          2                    16                                 20                        80.00%

2014          3                    14                                 31                        45.16%

2015          1                    20                                 29                        68.97%

2015          2                    19                                 38                        50.00%

2015          3                    9                                   25                        36.00%

2016          1                    23                                 28                        82.14%

2016          2                    27                                 41                        65.85% 

2016          3                    12                                 17                        70.59%

[v-yulgu-msft]

Hi @nleuck,

Based on my understanding, you want to calculate the year over year percent change of [Items Compliant] for each StoreID, right?

To achieve that requirement, I added some extra columns into original table, please see below:

DAX formulas for each calculated column:

previous Year = 'percent change'[Year]-1 & "," & 'percent change'[StoreID]

Current Year = 'percent change'[Year] & ","& 'percent change'[StoreID]

Previous Value =
LOOKUPVALUE (
    'percent change'[Items Compliant],
    'percent change'[Current Year], 'percent change'[previous Year]
)

Percent Change =
DIVIDE (
    'percent change'[Items Compliant] - 'percent change'[Previous Value],
    'percent change'[Previous Value]
)

Best regards,
Yuliana Gu

[nleuck]

@v-yulgu-msft

Thanks again, I needed to look at my data in a different way but I believe I've figured out my answer to my own question. Your formula helped realize I was looking at the data in the wrong way. Thanks again for your help.

[nleuck]

Thank you for your response. I'm actually wondering if it is possible to do the percent change calculation on the column %Compliant?