Create mapping column based on multiple columns

Anonymous — Tue, 10 Aug 2021 06:18:29 GMT

Hello,

I am new to power bi.

And im kind of stuck with one scenario.

Please consider following table as my Input table:

ID	Responsible Person	Domain	Org Unit
1	ABC	A
2	XYZ		UN1
3	PQR
4	XYZ
5	ABC		UN1
6	MNO	A
7	MNO
8	EFG
9	EFG	A
10	ABC

Now i need to visualize it as how many applications are there by per region. But region is not included in input table.

So i created a new mapping table. Region is derived by Respnsible person. Each distinct Responsible person is assigned for per region. Which i was able to achieve. But there was new regions addded which were not dependant on Responsible person but are responsible on column Domain and Org Unit.

So now what i want is where Domain is "A" is assigned to Region "Reg1".

Also where Org Unit is "UN1" is assigned to "Reg2".

And previous condition for deriving regions remains same(with responsible person).

I tried to achieve it by Conditional Column but it doesnt work properly.

The count doesnt match.

Can anyone please suggest me how do i approach this scenario.

Thanks in Advance..!!!

Re: Create mapping column based on multiple columns

Anonymous — Thu, 12 Aug 2021 02:52:12 GMT

Hi @Anonymous

Try to build a calculated column by switch function.

Region = SWITCH ( TRUE (), 'Table'[Domain] = "A", "Reg1", 'Table'[Org Unit] = "UN1", "Reg2", 'Table'[Responsible Person] )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Create mapping column based on multiple columns in Developer

Create mapping column based on multiple columns

Re: Create mapping column based on multiple columns