Forum Discussion
Adding data to one "cell" in a Power Query table
I need to add User Principal Name to an existing table for new people that come into the company. We do not have this information anywhere in our systems, so I normally just get it from the Power Bi service.
Is there a way to use Power Query editor to add a value to a particular row, and column (i.e. a cell) ? For example if I wanted to add the UPN to one of the cells below.
Hi Anonymous,
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)
BTW, if you mean the bulk replace with complex conditions, I'd like to suggest store them in another table and use a key field link to the raw table, it should be simple than manually coding formula replace values.
Regards,
Xiaoxin Sheng
2 Replies
- AllisonKennedy
Community Champion
Anonymous You could maintain this in Excel or in Power Query itself, then merge queries to pull that info through, but there's no way to edit an individual cell in Power Query without providing a condition or info on which row you need to change.
Hi Anonymous,
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)
BTW, if you mean the bulk replace with complex conditions, I'd like to suggest store them in another table and use a key field link to the raw table, it should be simple than manually coding formula replace values.
Regards,
Xiaoxin Sheng
