Phil, Thanks a lot for taking the time to explain the modifications (and 'try' 'otherwise'). That approach is much more efficient than the rout...
Why would that be? Isn't it essentially doing the same thing with the profile as with the count step? (I've never been able to use power query for...
I just discovered you can also see the total without inserting a step by changing the profile to operate over the entire dataset: In the lower-left co...
Yes, I'm afraid I don't get the approach. Are you saying the original Data_Table is used only once as a way to set up the subsequently used Data_Ta...
Many thanks for putting the time into trying to create a solution. I've been looking at the file and trying to work out what it's doing It seems cr...
Thanks for your reply I've attached a file with an example / explanation that looks like the image below. In reality my 'Data_Table' table ...
Thanks for your reply, How would you go about updating a table in this scenario ? e.g. I have table of records ('Data_Table') by customer from w...
Hi, I ran that code from Debra (interestingly I couldn't find it on her website for a full explanation in context). After I did that and reopened the...
Hi Catalin, When I try your code on my worksheet I get Run-time error '1004' Application-defined or object-defined error at this line: aSlicer.S...
Many thanks for your reply. Despite devoting 2 days to trying to learn basic Power Pivot, I'm severely struggling with the steep learning curve, so h...