Forum Discussion

Namoh's avatar
Namoh
Post Partisan
6 years ago
Solved

Max value from a column in Power Query Editor

Hi. I've got a very easy question, but somehow I can't get it to work. I have a table with multiple columns, one of them is called FiscalYear. I want to add another Calculated Column which shows t...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Namoh ,

     

    You need to add #”Change Type” before [FiscalYear].

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

Spigaw's avatar
Spigaw
Helper III
3 years ago

Hello,

I know this one is a bit old, but can you explain to me why adding the previous step to the code makes it work?

Thanks!

russhalep's avatar
russhalep
New Member
3 years ago

Late response, but for anyone else going through this answer, the reason it works is because you need to find the List.Max() of a list. If you just use the column name alone, it will use the value in that column within the same row - a single value - and throw an error since it's not a list. If you instead refer to it by "<previous step>"[column_name] (or <table_name>[column_name] depending on your query) you are looking for the List.Max() of that full array and it will return a value.