Power Query Max.List error help

[Anonymous]

Looking for help with this error. 

= Table.AddColumn(#"Filtered Rows", "Null Value ID", each if[XPO.ID]=null then List.Max([PI])+1 else[XPO. ID])

PI is a list of customer ID's.  They are formatted as numbers.  I want to return the max from that list +1 to create a unique number if there is no match to the list.  What am I missing?

Thanks,

Brian

[Anonymous · Accepted solution]

Hi @Anonymous,

You can use below formula to fix this issue:

= Table.AddColumn(#"Filtered Rows", "Null Value ID", each if[XPO.ID]=null then List.Max(#"Filtered Rows"[PI])+1 else[XPO. ID])

Notice: when you use each keyword with column name, it not mean value list of specific column, it will transform to detail cell value of that column.

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks, Xiaoxin!  I knew it would be some small snytax issue.