I have a data model and I want to insert a date; however, the date seems to have loaded intself with four categories (original source just had one):
- Date (y/m/d)*
- Date (month)
- Date (quarter)
- Date (Year)
* was the original format loaded into the model.
Now, whenever I try to load the date* into the model, the other three categories auto-populate and I end up with broken data (i.e. useless information) and the intended category to be filled remains excluded.
Totally lost on how to resolve this - thank you.
Resolved; working with very large data. I think Excel was being glitchy and not responding right to my original request. I toggled 'defer layout update' and it worked right.
Bookmarks