Forum Discussion
Solved
Inconsistent results when grouping. Works in Power Query in Excel, not in Power Query in PBI
I'm getting a strange result in Power Query. I was hoping writing it down and illustrating it with screenshots would make me realise what I'm doing wrong but I've got a Power Query that works in Exc...
I am sorry. I have found a difference in the source data. The methodology described above works perfectly. I am an idiot.
Just to be a bit more clear on the error, I end up with a Grouped Invoice - Project combination that does not exist in the original data. I can't see how the steps I am performing can do that.
I am sorry. I have found a difference in the source data. The methodology described above works perfectly. I am an idiot.