Urgent- Creating new column with value

[Anonymous]

Hello ,

I would like to create a new column which returns only the value for "TDC " which is part of the element of the "KPI" colum.

best regards, 
Kerrout 

[SpartaBI]

@Anonymous it's hard to see in the screenshot. Can you share the file/samle data
Also create a pseuodo column of the result you want to get (just enter the values).

[Anonymous]

KPI	Period Type	Cluster	Sub-Cluster	Market	Category	Business Area	NUM	Den	% of NNS		Pseudo
TDC	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	7766,07	250,0446	31,05874		31,058
Raw	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	2582,938	514,0446	5,024735		0
Pack	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	0	514,0446	0		0
Purch. 3P	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	-0,9082	514,0446	-0,00177		0
Var. Man. Exp.	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	4792,603	514,0446	9,323322		0
Purch. 3P IG	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	0	514,0446	0		0
COGS IG	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	7,2656	514,0446	0,014134		0
Exports	2022 YTD - 05	Aimmune	Aimmune PPAL	Aimmune PPAL	Pharma	Pharma	0	514,0446	0		0
Cash Discounts	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	73,5647	1718,3258	0,042812		0
Bad Goods Allow.	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	206,1628	1718,3258	0,119979		0
Distribution Allow.	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	227,0515	1718,3258	0,132135		0
Commission to Cust.	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	0	1718,3258	0		0
Consumer Price Reductions	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	634,836	1718,3258	0,36945		0
TTS	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	610,3145	3396,6904	0,179679		0
GGLF 3P	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	0	1718,3258	0		0
MC	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	926,3701	1718,3258	0,539112		0
VDC Tot	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	19,0723	1718,3258	0,011099		0
DC	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	32,6954	1718,3258	0,019027		0
DC Int	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	27,2462	1718,3258	0,015856		0
MGE	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	12635,87	1718,3258	7,353594		0
MGE Int	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	12635,87	1718,3258	7,353594		0
OGE	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	14864,61	1718,3258	8,650634		0
OGE Int	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	11170,03	1718,3258	6,500528		0
OP2	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	-47837	1718,3258	-27,8393		0
TDC	2022 YTD - 05	US	Total Palforzia	Palforzia US	Pharma	Pharma	343,9389	1718,3258	0,200159		0,200159

[Anonymous]

Here is the data, i would like to have a column which returns the TDC for each different cluster 

[SpartaBI · Accepted solution]

@Anonymous not 100% sure what you mean, but when looking at your sample data, you mean like this?:

Column = if('Table'[KPI] = "TDC", 'Table'[% of NNS], 0 )

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

Thanks boss !

[SpartaBI]

@Anonymous 😀 my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂