Forum Discussion

SaberSuM's avatar
SaberSuM
Frequent Visitor
2 years ago
Solved

Need help with Power Query, Suming with conditions

Hi,   Is there a anyway in power query to transform the sample data into the second table below. Basically, some employees need to split costs based on a ratio to other cost centres (B, C, D or E)....
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    use Record.RemoveFields instead

SaberSuM's avatar
SaberSuM
Frequent Visitor
2 years ago

is there anyway to avoid listing out the cost centres. The full list of cost centres might change on a monthly basis, and it would require constant updates to the code.

 

Thank you!

AlienSx's avatar
AlienSx
Super User
2 years ago

use Record.RemoveFields instead