Forum Discussion
Dax to M language
In power query, you can use Table.SelectRows(Source, each([Column] = Value)) to replace FILTER() in dax, use List.Sum() to replace SUMX() or SUM() indax, but there's no switch key word and syntax in power query, so you need to write a custom function, please refer to blogs below:
https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
In power query, you can use Table.SelectRows(Source, each([Column] = Value)) to replace FILTER() in dax, use List.Sum() to replace SUMX() or SUM() indax, but there's no switch key word and syntax in power query, so you need to write a custom function, please refer to blogs below:
https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.