Year to Year change and show the % difference and count of differences with a Unique Data set.

[crabcatcherAK]

I have this unique data set since I work for the local county government in the real estate division. All my data is basically the same base fields, just changes each year in regard to 'condition'. Here is a small example of my data set in excel. 

Each year, as new data updates comes in, the only main changes on this example that would change are the CDU/qual numbers. Usually +1 or -1 from previous. Like this...

I think I need to create a measure to show change. 

Almost all the videos I have watched, ask me to create a date table (from the beginning date of my entire data set, to the last day of my data set) and then link  them in my model. Done all that! 

What to do next? I have tried creating these measures and having them all available to me. 

1. 17 cdu change= sum(_2017_all_data[cdu]) 

2. '17 total cdu change Ly= calculate ([17 CDU change], sameperiodlastyear ( '5 year date table'[date])) 

3.  17diffFromLYtoTY = IF(ISBLANK([17 total CDU change LY]),BLANK(),[17 CDU change]-[17 total CDU change LY]). 

Per some videos, after creating the measures and apply the 'date table' as a filter, should show the changes of CDU, from year to year. What am I doing wrong when getting this error message? 

[Fowmy · Accepted solution]

@crabcatcherAK 

You cannot sum a text column, change the data type to a number

Chech the column: 2017_all_data[cdu]

[crabcatcherAK]

Gotcha. Just did that. Should I be creating those same 3 measures that I did for _2017, for also _2018,_2019,_2020, and _2021 that way the values, % change y2y can be displayed? 

[Fowmy]

@crabcatcherAK 

Yes, those measures look fine.