Forum Discussion
Resolver ICreated 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 include any data from 2019. If I choose only 2018 data the visuals and reports work fine.
Is there a step I'm issing with regard to completing the Append or maybe some connection/relation that I still have to do. Any information on this will help.
Thanks so much,
John
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
3 Replies
- jdbuchanan71
Super User
Do you have a date table that is missing the dates from 2019 maybe?
kozlevcharAll dates are there. No blanks. Thanks
- kozlevchar
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
