How Do I Speed Up My PowerQuery

My powerquery is so slow even though I tried to make it faster. The data In working with is just the raw data and I’m tasked with converting everything into something else through custom columns.

These custom columns use legends by merges and are nested if statements. The excel equivalent would be vlookups with nested ifs.

I made a library inside Powerquery that houses that logic.

I also branched the query into 2, one where the columns aren’t used in the custom column creation and another where it is. I know this decrease the amount of data since the columns went from 20s to 7-8.

The issue is the data doesn’t load. And I didn’t even remerge the constant with the custom columns throigh an index column, then append everything.

I tried Buffering the alleged which didn’t do a thing