Forum Discussion
Solved
Getting Invalid Cell Reference after LeftAnti merge
I recently upgraded to Power BI Desktop Version: 2.59.5135.421 64-bit (June, 2018) I have a large table (30K lines) with a few lines I needed to correct, so I copied the offending lines to a new ...
I was barking up the wrong tree here. Someone entered #REF! as a value in a single cell in one of my sources. It wasn't a formula so Excel's find function couldn't find it.
I fixed it with a ReplaceErrorValue function.
I was barking up the wrong tree here. Someone entered #REF! as a value in a single cell in one of my sources. It wasn't a formula so Excel's find function couldn't find it.
I fixed it with a ReplaceErrorValue function.