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...
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.