Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Urgent- Creating new column with value

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 
Need Help
Show and Tell
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago
KPIPeriod TypeClusterSub-ClusterMarketCategoryBusiness AreaNUMDen% of NNS Pseudo 
TDC2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma7766,07250,044631,05874 31,058
Raw2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma2582,938514,04465,024735 0
Pack2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
Purch. 3P2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma-0,9082514,0446-0,00177 0
Var. Man. Exp.2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma4792,603514,04469,323322 0
Purch. 3P IG2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
COGS IG2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma7,2656514,04460,014134 0
Exports2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
Cash Discounts2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma73,56471718,32580,042812 0
Bad Goods Allow.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma206,16281718,32580,119979 0
Distribution Allow.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma227,05151718,32580,132135 0
Commission to Cust.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma01718,32580 0
Consumer Price Reductions2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma634,8361718,32580,36945 0
TTS2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma610,31453396,69040,179679 0
GGLF 3P2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma01718,32580 0
MC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma926,37011718,32580,539112 0
VDC Tot2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma19,07231718,32580,011099 0
DC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma32,69541718,32580,019027 0
DC Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma27,24621718,32580,015856 0
MGE2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma12635,871718,32587,353594 0
MGE Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma12635,871718,32587,353594 0
OGE2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma14864,611718,32588,650634 0
OGE Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma11170,031718,32586,500528 0
OP22022 YTD - 05US Total PalforziaPalforzia USPharmaPharma-478371718,3258-27,8393 0
TDC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma343,93891718,32580,200159 0,200159
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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