Forum Discussion
Correct data in a calculated column
Hi there, I'm working with a column that has multiple key/value pairs which has inconsistant entries, i.e. not all rows have the same key/values. I have a calculated column based on this that ex...
Hi,
Data cleaning should be done as far upstram as is possible. If it is not possible to make such spelling corrections in the source dataset, then one should do so in Power Query. If you are amenable to my approach, then share some data to work with and in a spare column, show the expected result.
I appreciate your response. The data is coming from Azure Cost Management and the field in question is tagged with the data at time of charge. So you see there is no way to retrospectively fix the data at the source for past charges. As for Power Query, yes you can make changes there but you cannot work with a calculated column in Power Query can you?
Cheers,
Marc
We can write formulas in a column using Power Query.