Forum Discussion
Aggregate data with identical attributes while keeping the data in sequence using a DAX measure
Can you post a representative sample of your data that can be copied and pasted? I want to understand how your data is laid out so that I present a solution that is useable. Are Sales Rep, Client and Month all their own dimension tables?
In general, what I would do however would be to start a measure with a SUMMARIZE. Then use ADDCOLUMNS to add what you would normally do as a calculated column using EARLIER to figure out if something has changed.
Unfortunately, there are many reasons why I cannot post a sample of my data. Perhaps the most important reason being that I am contractually prevented from doing so.
Assume that Sales Rep is in the fact table with Units Sold. Assume that Client is is its own dimension table, and Month is also in its own dimension table.
Your suggested functions for the basic structure of the measure sound like they might do what I am looking for. Unfortunately, I have no experience with Add Columns, so I will do some reading and attempt to put something together.
Thanks for your help!