There's no magic translator. Just step through what the formula is actually doing, and replicate the function in Power Query.