Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Using Queries in Powerpivot and excel2010 is it possible?

Hi,
I am trying to do  somthing described in this Blog:
DAX Queries in Excel 2013 : using ROLLUP to cover some UNION scenarios
But I dont't know where could I insert the dax-query.
I have made a linked tabel.
And tried:
Measure:
Measure 1:=SUMMARIZE(Games;[Player 1])

Open in new window

... Error
Column:
=SUMMARIZE(Games;[Player 1])

Open in new window

...Error
In the excel sheet I could not find SUMMARIZE function.

Is that only possible in Excel 2013
or is that only possible with sql server?

THX
0
wope
Asked:
wope
1 Solution
 
Rory ArchibaldCommented:
See the previous article here: http://thedataspecialist.wordpress.com/2012/07/20/dax-queries-in-excel-2013/
for the how-to part of using the DAX query. Yes, this only works in Excel 2013.
0
 
wopeAuthor Commented:
THX
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now