Created Measures not recognizing Appended Data

[kozlevchar]

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 

[jdbuchanan71]

Do you have a date table that is missing the dates from 2019 maybe?

[kozlevchar]

All dates are there.  No blanks.  Thanks

[kozlevchar · Accepted solution]

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