topic Re: Help translating/looking up test values to a different value in DAX Commands and Tips

Help translating/looking up test values to a different value

Anonymous — Thu, 23 Jan 2020 16:47:53 GMT

I have a table of resources mapped from Project Online that have a "Department" value defined for each. I have a requirement to map this department value to a Business Unit value.

I looking or advise on the best way to achieve this. My initial thoughts are somehow creating a lookup table in PowerBI to map this (not sure on the feasibility of this), or creating some form of DAX to map values.

Any help would be greatly appreciated.

Re: Help translating/looking up test values to a different value

Anonymous — Fri, 24 Jan 2020 18:19:15 GMT

Hi Anonymous ,

I guess you already have a way to "link" the department to the business unit. Something like a Organisation Breakdown Structure.

So you could create a departement table with DEPNO, DESCRIPTION, .... any other department related fields like manager... and BUSINESSUNIT. Add a field DEPNO to you resource table and create relationships between the tables.

Hope this helps,

Jan