1

I would like to add a custom column C in my Power BI query (meaning M language, not DAX) so that each value of column B gets divided by the MAX() of column A.

Can't make this work:

Table.AddColumn(#"Changed Type", "Custom", each [B] / List.Max([Total Score]))

I get the error:

We cannot convert the value null to type List

Degan
  • 989
  • 2
  • 16
  • 30
Julien Allard
  • 11
  • 2

1 Answers1

2

Try: Table.AddColumn(#"Changed Type", "Custom", each [B] / List.Max(#"Changed Type"[Total Score]))

Marc Pincince
  • 4,987
  • 6
  • 19
  • 40