Forum Discussion
kozlevchar
Resolver I
7 years agoCreated Measures not recognizing Appended Data
Hi, I have appended a newly created query (with 2019) data) to an existing one (2018 data). While the reports will list any raw data from 2019, my reports with created 'measures' will not includ...
- 7 years ago
I found the issue. I had renamed some columns in the original Query but did not do so in the Appended Query. Once I changed the name in the 2019 Query and refreshed. The Meausres worked
jdbuchanan71
Super User
7 years agoDo you have a date table that is missing the dates from 2019 maybe?
- kozlevchar7 years ago
Resolver I
All dates are there. No blanks. Thanks
- kozlevchar7 years ago
Resolver I
I found the issue. I had renamed some columns in the original Query but did not do so in the Appended Query. Once I changed the name in the 2019 Query and refreshed. The Meausres worked