Forum Discussion
Converting Excel Formula to M Query Language
Hello, I am new to M query language, however I have need to covert a fairly complex excel formula into M. I’m not looking to have the formula written for me, but if there are any tips, pointers, or ...
Anonymous,
For MIN and MAX, you can use List.Min() and List.Max() in M. For YEAR, use Date.Year(). There is no equivalent function in M , but you can use Merge Queries transformation in Query Editor to pull in the look up column.