Thanks Mynda! I'll see if that works for. I don't think I can delete the 'original query with the two name columns' because the clients' employees...
Thanks for the reply, Mynda. I'll use your Fuzzy Matching sheet to demonstrate. You have a list of companies and products, but the company name is...
Most of what I was misunderstanding is explained in Mynda's video 6.07 Ideal Data Structure for Power Pivot. It took a few times watching it and ma...
I just got of the call with Microsoft. Their answer was that the QBO connection is still in development so there are likely to be problems and they r...
Thanks, Riny. I think that's getting me closer. I'll keep playing around with it and see if I can define my problem better. I'll also re-watch al...
I should mention, I've tried adding a date table and linking it to the Fact table, but that doesn't really do anything. I've also tried adding a s...
Thanks, Catalin. I've scheduled a call with Microsoft to see if there's a more elegant solution. If they find one, I'll post back here. -Nat...
Thanks. Does that mean that any time I am going to want a running total, I need to add a column in Power Query with the field that I'll want to use i...
Never mind. In the magnifying glass, they've added lines in separate categories (min, max, etc.) instead of having 1 place called 'reference line'.