Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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!!
what's the expected output?
_PRODUCT_gg_SEQ01 or 01?
What if for those numbers are two digits, do you still want to add 0?
Proud to be a Super User!
Hi @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!!
sorry i dont get it how
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!!
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
Nope it will do the same transformation for all the new data as well you need to give the data correctly for couple of examples to make power query to understand.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |