Forum Discussion
benqpbi
Helper I
Helper IHow to add value in column which is not consistent
I have a column named task name which is incosistent but i want to add zero before my 1,2 and so on... how do i add in power query/ m-code so it is future proof
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!!
Jayee
Responsive Resident
Responsive ResidentCheck 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!!
benqpbiHelper I
Helper Ihey 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