How to change the format of the table based on rows?

[Oguzhan0556]

Hi!

I have a table with 10 rows and 2 columns. I want to do a study on the "Ay1" column. The format of the “Ay1” column is set to text. However, some lines consist of numbers. How can I set some rows in the "Ay1" column as text and some rows as integers?

What I want to do may seem interesting, but it has a logical explanation 😊

Thank you...

[Oguzhan0556]

Thank you all!

[djurecicK2 · Accepted solution]

Hi @Oguzhan0556 ,

 You can only have 1 data type per column. However, you can use the VALUE or CONVERT function in your measures or calculated columns if you need to switch between types.

Value:

https://learn.microsoft.com/en-us/dax/value-function-dax

Convert:

https://learn.microsoft.com/en-us/dax/convert-function-dax

Please accept as solution if this answers the question- thanks!

[amitchandak]

@Oguzhan0556 , You can same data type in dax, so you can use format, function to format the integers in a format , but you can not have mixed data type