Different Date Types for same Column

Hi,

You can very easily create a New Column, and use the IF formula to conditionally format each Row's value based on the values in your KPI column.

So, if e.g. your Table's name is Table1, and it has two columns "KPI", and "Figure", where KPI column contains labels such as "Hits", "Conversion", and you want to convert each Conversion figure as % but all other as Integers or a Standard Number, you can use the following formula in a New Column to conditionally format each row:

New Column = IF(Table1[KPI]="Conversion",FORMAT(Table1[Figure],"Percent"),FORMAT(Table1[Figure],"Standard"))

For more FORMAT options, you can visit these links:

https://technet.microsoft.com/en-us/library/ee634561(v=sql.105).aspx

https://technet.microsoft.com/en-us/library/ee634206(v=sql.105).aspx

Hope this helps.

Asad Hamdani