Log In
Register
Home
January 13, 2021
Offline
Hello,
After updating one of my Tables and refreshing all, power query and the data model shows the correct number of rows and everything but different contents in one of the columns than what Is actually listed in that column from my ‘Table’ (external data source). It happens to be a column for the Year that gets entered manually. 2021 is in the entire column and power query and data model shows 2020!? It’s not detecting for some reason. Has ever happened before?
Thank you
July 16, 2010
Offline
Hi Jen,
I'd need to see the file or at least screenshots that document the entire data flow.
Mynda
January 13, 2021
Offline
I corrected this in power query by duplicating the date column, then extracted the year and replacing this New column as my Year column so that my slicers work. All okay now. Thank you.
The following users say thank you to Jen Smith for this useful post:
Mynda Treacy
