Table data in UPPER case

[ak77]

Hi Gurus,

need a help if anyone came across this case.please check.

i have a table with huge dataset and  columns called O_Asset Class, portfolio override coming from a sql table. i have a switch statment which has a logic 

All the cases are working fine, but in one case. the data is getting to UPPER case(TOTAL INFRASTRUCTURE . Does anyone have any idea why this UPPER case is happening? 

These 2 columns are from DB 

 

 

Below is the Switch statment result:

Switch Asset/Sub-Class Benchmark = SWITCH (

    TRUE,

 (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Benchmark")) && (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Excess"))) && LEN(Client_Returns_Data[Portfolio_Node_Name_Override])=0),Client_Returns_Data[O_Asset/Sub-Class Benchmark], (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Benchmark")) && (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Excess"))) && LEN(Client_Returns_Data[Portfolio_Node_Name_Override])>0),Client_Returns_Data[Portfolio_Node_Name_Override],

 Client_Returns_Data[O_Asset/Sub-Class Benchmark]

)

Sounds really wierd

[parry2k]

@ak77 sorry not sure what you are trying to achieve. 

[ak77]

@parry2k , Apologies for getting back bit late and yes there is one value with TOTAL INFRASTRUCTURE in upper case in the data set which was lately found during analysis. so is there a way to retain these cases for a particular column

[parry2k]

@ak77 this is so strange, can you check in PQ?

[ak77]

@parry2k .Thanks for reply..i had checked it.. verified again now.. there is no translation in PQ.. and in the table view u can see what exactly is coming from DB after power query execution and its normal case 

[parry2k]

@ak77 weird, can you double check if there are two values from DB, one with Upper case?

[ak77]

@parry2k , Yup checked. whole dataset does nt have this upper case in DB