Forum Discussion
Helper IHow to add value in column which is not consistent
Check this document from Microsoft it is very simple in terms of steps you need to follow.
https://learn.microsoft.com/en-us/power-query/column-from-example
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Responsive ResidentHi benqpbi
Use Column from examples transformation in power query and provide some examples in the column highlited then power query will write M code automatically.
I can able to sort with the data you have provided
Here the link for same file
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
benqpbisorry i dont get it how
- Jayee
Check this document from Microsoft it is very simple in terms of steps you need to follow.
https://learn.microsoft.com/en-us/power-query/column-from-example
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
- benqpbi
hey jay thanks just tried but it creates a if else statement which is not possible since when new data comes it might be wrong, any other solution if possible