Dax Formula error: the name sumx wasn't recognised

[LSP0weR31]

Hi there,

I'm trying to get this formula to give me a custom culomn that creates a 'Spend Profile" for each vendor in the dataset per month.  I get the error the name sumx wasn't recognised, however, I'm sure that is not the only issue with this forumla.

if [Vendor Code] = [Vendor Code] and [#"Fiscal year/period"] = [#"Fiscal year/period"] and SUMX([#"FEB 2017 - JAN 2018"]) <100000 then "<100k" else if [Vendor Code] = [Vendor Code] and [#"Fiscal year/period"] = [#"Fiscal year/period"] and SUMX([#"FEB 2017 - JAN 2018"]) >100000 <250000 then ">100k <250k" else if [Vendor Code] = [Vendor Code] and [#"Fiscal year/period"] = [#"Fiscal year/period"] and SUMX([#"FEB 2017 - JAN 2018"]) > 250000 < 500000 then ">250k <500k" else if [Vendor Code] = [Vendor Code] and [#"Fiscal year/period"] = [#"Fiscal year/period"] and SUMX([#"FEB 2017 - JAN 2018"]) > 500000 < 1000000 then ">500k <1M" else "0"

Any ideas?

[Zubair_Muhammad · Accepted solution]

@LSP0weR31

SUMX is a DAX function. It won't work in Query Editor.

I think your formula would work fine without it

[LSP0weR31]

Thank you! It worked perfectly without it.

Very grateful for your quick response and super simple solution.