Hello all,
I have a PowerPivot model set up several tables. One is series of jobs, another is all of the costs broken out by line item (each is associated with a job). Each cost has a financial period associated with it. There is a certain cost code (call it XYZ) that is associated with the beginning of the job. Most of these have only one cost with this cost code, but some have more than one.
The English for the equation I'm trying to get to is "The earliest financial period associated with Cost Code XYZ for Job A." This could be in its own table with a list of the jobs, or anywhere else I can run in my powerpivot table. This seems like the most intuitive place to put it, but I can build this model to accommodate a variety of solutions.
I'm a real neophyte with DAX. Just got the relationships working yesterday, and I'm trying to put this piece together today.
Any and all help, links to resources useful for issues like this, etc. is appreciated.
Thanks,
DWig
I have a PowerPivot model set up several tables. One is series of jobs, another is all of the costs broken out by line item (each is associated with a job). Each cost has a financial period associated with it. There is a certain cost code (call it XYZ) that is associated with the beginning of the job. Most of these have only one cost with this cost code, but some have more than one.
The English for the equation I'm trying to get to is "The earliest financial period associated with Cost Code XYZ for Job A." This could be in its own table with a list of the jobs, or anywhere else I can run in my powerpivot table. This seems like the most intuitive place to put it, but I can build this model to accommodate a variety of solutions.
I'm a real neophyte with DAX. Just got the relationships working yesterday, and I'm trying to put this piece together today.
Any and all help, links to resources useful for issues like this, etc. is appreciated.
Thanks,
DWig