Forum Discussion

sjpaq's avatar
sjpaq
Icon for Helper I rankHelper I
2 years ago

Table.TransformColumns Error

I have a powerQuery which combines 2 tables. The resulting table has a few columns that are null as a result of the combine. In one case, I am able to replace the null value with a text value using a...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi sjpaq 

Can you please try 

 

= Table.TransformColumns(Source, {"Amount", each if [YourColumnName]=null and [IndName] = "Response Costs") then ([Hours] * [Hourly Rate]) else ""})

Or 

Add new column
 = Table.AddColumn(Source, "Amount", each if [YourColumnName]=null and [IndName] = "Response Costs" then ([Hours]*[Hourly Rate]) else ""}

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin