hi Mynda I got all that bit working - I basically rolled it back, and did the date re-formatting at the beginning. So that's working 🙂 Thank you ...
That's what I am getting. How should I rectify it? Thanks. I'm now tantalisingly close to getting this project over the line. Planning to finish it of...
hi Mynda That's brill. Will check it out. Thanks.
Well at least I now know I wasn't losing my (Excel) mind completely! OK, so can I structure those formulas the same in Power Query or where would I fi...
You were right (as usual!). I had set the data types to date and refreshed but because some of the date entries were blank, it made the whole lot "Any...
Well DOH! on my part. I'm sending you a mockup of the actual file I use. The only steps I implemented were: 1. Unpivot other columns from I to CFO ...
So I have two columns that are not transferring properly...I've changed them both to Date/Time in PQ 1. Column is called: Contract Start Date. This...
Excellent. I am using Excel 2016. Presume I need to create the Powerpivot data model first...and then pull it in...thank you 🙂