DAX working in PBI but not Excel

[Anonymous]

Hi All, 

I got the below query - it works fine in PowerBi but in Excel, I get the error "Invalid Query syntax. A valid MDX or DAX query was expected." - what's going on?

=
SUMMARIZE (
    Table14,
    Table14.[X],
    Table14.[Y],
    Table14.[Z],
    "Start Date", MIN ( Table14[Received on] ),
    "End Date", MAX ( Table14[Received on] ),
    "Male", CALCULATE ( COUNT ( Table14[Gender] ), Table14[Gender] = "1" ),
    "Female", CALCULATE ( COUNT ( Table14[Gender] ), Table14[Gender] = "2" ),
    "Indicator", "SALES",
    "Location", IF ( Table14[Z] = "A", "A", "Other" )
)

Best,

Dat_Data

[sturlaws]

Hi,
what is the context for this error? Are you trying to use the same code in Excel Power Pivot?

-s

[Anonymous]

Hi @sturlaws 

I'm trying to run this through DAX studio on Excel but I also get a similar response with Power Pivot.

Best, 

Dat_Data