topic Re: DAX working in PBI but not Excel in DAX Commands and Tips

DAX working in PBI but not Excel

Anonymous — Sun, 15 Sep 2019 13:46:48 GMT

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

Re: DAX working in PBI but not Excel

sturlaws — Mon, 16 Sep 2019 15:04:41 GMT

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

-s

Re: DAX working in PBI but not Excel

Anonymous — Tue, 17 Sep 2019 11:52:20 GMT

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