Forum Discussion

VSrujana's avatar
VSrujana
Frequent Visitor
5 years ago
Solved

Row wise calculation in power query

I have a table with two columns Attribute and Value Attribute Value A 3000 B null I would like to replace the null value with 30% of the corresponding value of A. I do not wan...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    your example is really minimalist (at the very least, to get a meaningful answer, you should better explain what kind of "correspondence" there is between A and B. ).

     

    In any case, the attached proposal works for a very large database and on the assumption that the nulls (which can be even more than 1) to be filled with the percentages are all consecutive and following the number available

Anonymous's avatar
Anonymous
Not applicable
5 years ago

your example is really minimalist (at the very least, to get a meaningful answer, you should better explain what kind of "correspondence" there is between A and B. ).

 

In any case, the attached proposal works for a very large database and on the assumption that the nulls (which can be even more than 1) to be filled with the percentages are all consecutive and following the number available