Forum Discussion
How do you stop Power Bi Desktop rounding decimal numbers to a whole number?
I have created a new column which uses the Switch function to negate a value under certain conditions. INVENTORY_VALUE = SWITCH(TRX_DATA[RMS_TRANSACTION_CODE],"1",(TRX_DATA[RETAIL_VALUE]*-1.00)...
AllisonKennedy
Community Champion
Community ChampionJPRogers Can you upload a sample report demonstrating the issue and share via OneDrive please?
What's the data type of [RMS_TRANSACTION_CODE], not sure but this may be part of the issue?
Hi Alison,
Thank you for your reply, the column RMS_TRANSACTION_CODE is a text column. Do you think that it is influencing the result adversely? How do I get round that?