Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Morning,
Due to how a data source is set up certain cells are pulling in as 'null' where there should be text (this can't be changed).
Is it possible to manually add text to an individual cell in Power Query? I can find a lot of text transformation options for adjusting the entire column but I only want to add text manually to specific cells that is not pulled in from the data source.
Thank you! 🙂
Solved! Go to Solution.
Hi @pigsinblankets ,
It sounds like you want to do accurately replace specific row values, right? If that's the case, you can take a look at the following link about M query operators(column: [string], row {number}), then you can do custom on replace function to achieve accurately replace value operations.
Operators - PowerQuery M | Microsoft Docs
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query (biinsight.com)
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
Hii @pigsinblankets ,
If you want to edit cells manually go to power query and in the applied steps section, click on the source and then click on this little gear icon. Then you can edit your data manually.
Hope it helps and please let me know if this helps you or not.
Hi @pigsinblankets ,
It sounds like you want to do accurately replace specific row values, right? If that's the case, you can take a look at the following link about M query operators(column: [string], row {number}), then you can do custom on replace function to achieve accurately replace value operations.
Operators - PowerQuery M | Microsoft Docs
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query (biinsight.com)
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |