Forum Discussion

CoffeeTime's avatar
CoffeeTime
Frequent Visitor
6 years ago
Solved

Power Query: List.Max dosn't return max value

I extracted a number from a code and converted it to number in column "NewCode". Then, I would like to create a column with the max value of "NewCode".      Then I added a new custom column:...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi CoffeeTime ,

     

    I made a sample about using list.Max,and it worked fine.

     

    Be sure that you have changed your column type to "whole number".

     
    Here is the related .pbix file.
     
     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

az38's avatar
az38
Community Champion
6 years ago

Hi CoffeeTime 

it's better to create a DAX calculated column

Column = MAX(Table[NewCode])
Gareth123's avatar
Gareth123
Regular Visitor
2 years ago

Why do you think it is better to use DAX?