Forum Discussion
Solved
Column with different data types
Dear all, I would need your support if possible.. Currently within my dataset there is a table "SUM" like below, where columns "Jan" and "Feb" contains both decimal and whole numbers data types....
Hi cs141005 ，
First of all, all values of one field can only have one data type. If the data type of the field Jan and Feb is Numeric type and later the values in these two fields need to participate in the calculation, it will not be possible to achieve the result you want. If their data type is Text type, you can use FORMAT function to change their data form just as shown in the below screenshot. Please find the details in the attachment.
Use custom format strings in Power BI Desktop
Best Regards
