Cthulhu
Why Cthulhu? Because the mental gymnastics required to figure this out nearly drove me insane. And because the exact reason you would need this measure is probably beyond the comprehension of mere mo...
Power Query uses M, not DAX. It's a completely different language.
Ah.... well I feel slightly foolish.... will keep learning, thank you for responding!