Forum Discussion
Glitch with Conditional columns
I have a problem with the data type of a conditional colum. I have a whole Number column I am modifying to group values together, but the output is being treated as text and not a whole number. I ca...
Hi Anonymous ，
You need to create a measure to change your value,using fixed(value,number),number here equals the number of decimal places.
As you see below:
If you choose "0",it will convert into a int like number.But it's text type.
Here is the reference.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi Anonymous ,
Does amitchandak 's suggestion work?
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
It does not work for me, as the Data view does not show DirectQuery tables.
Hi Anonymous ，
You need to create a measure to change your value,using fixed(value,number),number here equals the number of decimal places.
As you see below:
If you choose "0",it will convert into a int like number.But it's text type.
Here is the reference.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!