Greg_Deckler
Community Champion
Community ChampionCthulhu
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...
AlexisOlson
Super User
Super UserI think I found a cleaner approach:
Local Group Index =
VAR _CurrIndex = MAX ( Cthulhu[Index] )
VAR _CurrGroup = MAX ( Cthulhu[Animal] )
VAR _LocalGroupStart =
CALCULATE (
MAX ( Cthulhu[Index] ),
ALLSELECTED ( Cthulhu ),
Cthulhu[Index] < _CurrIndex,
Cthulhu[Animal] <> _CurrGroup
)
VAR _LocalIndex = _CurrIndex - _LocalGroupStart
RETURN
_LocalIndex
Hello, I am very new to Power Query, just started watching videos on how to use yesterday... I typed this in and I keep getting a Token Eof expected, I have tried to remove the Local Group Index part and still happens, please help, this is what I need to finish this sheet, thank you!
- AlexisOlson
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!