Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have this DataFormat.Error because of the symbols around the number.
I've tried to change to text and use replace values for each of the symbols but it doesn't do anything.
Has anyone else come across this problem?
Solved! Go to Solution.
Hi Fowmy, thanks for the reply, I've spent all day looking for answers and then when I ask for help suddenly it works.
I had a custom function to expand tables that had a change type inside, so I removed the change type and then I could remove the symbols.
Note that the split function supports custom logic, including the transition between numbers and non-numbers.
@victoria_g06
Please share some sample data where you have this symbols included. you can paste it in your reply.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy, thanks for the reply, I've spent all day looking for answers and then when I ask for help suddenly it works.
I had a custom function to expand tables that had a change type inside, so I removed the change type and then I could remove the symbols.