Have both whole number and decimal values in single column . I want to display as it is (whole number should display 1 and decimal number should display 0,5)
Column = SWITCH(TRUE();TABLE[FROM DATE]=TABLE[Active Date];0,5;TABLE[TILL DATE]=TABLE[Active Date];0,5;ROUND(1;0))
After my research, I'm afraid it couldn't achieve in Power BI for now.
when you set the format and this whole column will have the same format.unless you set the format is Text.
For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.