Forum Discussion
Row over row logic
A bit stumped here. Trying to enhance a dataset with a column that uses some logic. The data is coming from general ledger entries with the the two (or more) accounts an document posts to. Wh...
Uh oh.
Added the column to the actual data, ~550k rows, and Power BI just spins "Working on it"....
Anyone have tips for optimization? Maybe replicate this logic with M? But how?
Not sure what your data architecture/data structure looks like, but if I were you, I would try to put a calculation like this on the DB side. It's at the lowest grain of data and could just be incorporated into your driving table.