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


          

SpartaBI's avatar
SpartaBI
Community Champion
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

Thanks boss !