Forum Discussion
DAX function to M language?
I have the following DAX function which works in Power BI. New Formula Output = IF('Global DSR MTMS'[TOTAL WEIGHT]>(19958 * 0.85), "Optimized", SWITCH('Global DSR MTMS'[EQUIPMENT TYPE], "20FT_C...
Greg_Deckler
Community Champion
Community ChampionTake a look at this for help in replicating your SWITCH statement in Power Query. I assume that's where the stumbling block is:
https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/