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.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
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.

Namoh's avatar
Namoh
Post Partisan
6 years ago

Thanks, this methiod worked.

 

I had to change "Changed Type" into my own column name and that did the trick!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Good to hear, please mark the solution as accepted