Power Pivot  DAX Functions

Posted on 2011-09-28
Medium Priority
Last Modified: 2012-05-12
My company and i are looking to solve a soltuon for Analysi of change work IN powerPivot using DAx langauge
we think this might be achieved using EARLIER function- Looked on google and samples are very technical - ie copied from MS technet
would like working sample and /or help with same,
Project work potential
Question by:scottyhyde
  • 2

Expert Comment

ID: 36894093
So can you provide examples of what you are trying to accomplish?  Please provide and explanation of the problem, and if possible, post a file.  

Accepted Solution

scottyhyde earned 0 total points
ID: 36900953
Hi there
see attached
If you see calculated columns in Table 1 in POWER PIVOT youll see the Example and parent columns
currently EXAMPLE calc FILTER refers to "node1" (as text)
but id like that filter to  use associated parent - like a Sumif criteria that refers to a dynamic cell reference rather than "node1" text

appreciate any thoughts

Author Closing Comment

ID: 37175815
No answer

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question