Forum Discussion
Solved
Remove unnecessary character from data
Hi, In the below example, how can I romove "A" and "*" when my data get loaded to power BI. Basically, I want my data to be loaded as Date type to Power Bi. But, some records have additional charac...
Hi amirghaderi ,
My mistake.
Actually you could directly use Replace Values feature in Query Editor.
Best Regards,
Jay
Thanks,
In formula, if I have as below, it will remove A from any month which has A, like April,
= Table.AddColumn(#"Promoted Headers", "Custom", each Text.Remove([Date],"A"))
If I put one space before A, then the formula, gives an error.
Hi amirghaderi ,
My mistake.
Actually you could directly use Replace Values feature in Query Editor.
Best Regards,
Jay