Number format in InMemory
I got a problem with Excel data imported to InMemory ETL. The (Measure) data is being read as string and I want to format it with a CAST function. However, none of the normal Cast functions seems to work and gives an error. It does not matter if I do it at the stage level or within the ME database.
Can you advice how to handle this?