Hi Mynda, thanks, but this is about power query only - no power pivot involved and also no loading to the data model (completly empty). Also in ...
Yes, excellent reference from an excellent source!
Hi Cătălin, And thanks for not giving up! 1. Ok, so indeed macros have to be activated. The welcome page could request activating the macros. Ye...
Hi Catalin, e.g. "SECURITY WARNING: Some active content has been deactivated." You have to press "Enable Content" before any macro could run.
Hi Catalin, new PQ Version: 2.54.4970.321 (PQ-CY18SU01) (x86) i.e. 32-bit Unexpected Error Could not load file or assembly 'Localytics, Version...
PQ version: 2.49.4831.381 32-bit, so indeed not the freshest one attached the sample file once more, this time with: -filtered query to demonstrate...
Hi Catalin, thanks for the follow up! Yes I have the issues. And you can see that the lines 104, 106, 108 and 110 are "missing" although no filt...
Hi Catalin, Bad that we would have to go for an alternative solution. Nice idea, and the sumifs themselfs are not the problem: I could emulate t...
Hi Mynda, I simplified the query and I hope it illustrates what I explained with words in my above two posts. Thanks for the endeavors, Matthias
Hi Mynda, without that formula column there are no filter issues. Actually also the table length did not change as the data itself is unchanged. ...
Thanks, Mynda! That helped a lot, with this info I could use List.Max exactly how I needed it. Thanks again, Matthias
Thanks a lot, Catalin. That's a good proposal!