Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@crabcatcherAK
You cannot sum a text column, change the data type to a number
Chech the column: 2017_all_data[cdu]
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@crabcatcherAK
You cannot sum a text column, change the data type to a number
Chech the column: 2017_all_data[cdu]
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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?
@crabcatcherAK
Yes, those measures look fine.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |