Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Gérard Ducouret]

Hi,
I copied the following query from “The Definitive Guide to DAX” page 422 but I always get an error  in DAX studio:
Query (3,2) the “5” argument in the SUMMARIZE function is required.

EVALUATE
ADDCOLUMNS (
    SUMMARIZE (
        Sales,
        ‘Date'[Calendar Year],
        ‘Date'[Month],
        ‘Date'[Month Number],
    ),
    “Amt”, AVERAGEX (
        RELATEDTABLE ( Sales ),
        Sales[Quantity] * Sales[Net Price]
    )
)
ORDER BY
    ‘Date'[Calendar Year],
    ‘Date'[Month Number]

What did I miss?

Thanks for your help

——————————
Gérard Ducouret
——————————

[Alison Box]

Hi Gerard
There should be no comma after “Date[Month Number]”

——————————
Alison Box
Burningsuit Ltd
0800 0199 746
——————————
——————————————-

[Gérard Ducouret]

Hi Alison,
Great! That work!
NB : The error was also in the book. Strange ,

——————————
Gérard Ducouret
——————————
——————————————-