Power query to reconcile accounts that do not have a common column
#excel #powerbi #powerquery
Learn how to reconcile accounts that do not have a common column using power query. This video is a follow on to the article
theexcelclub.com/how-to-recon...
and video • How to Reconcile Accou...
where you learn to reconcile accounts such as bank accounts using Power Query. However, in that article and video, both sets of records had a common column.
This video shows you what to do when you do not have a common column in tables you are trying to reconcile with Power Query
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist
Пікірлер: 17
Hi Paula.. great trick.. thanks for sharing it. Thumbs up for The Excel Club!!
Life saving. Thank you
Thank you so much!!! This helped me out a ton!!!
Thanks, Paula this is simple and powerful
@PaulaWeb3andCrypto
3 жыл бұрын
good stuff!!
I really need this, am following it.
@PaulaWeb3andCrypto
3 жыл бұрын
:-)
Awesome trick. This video is very helpful and valuable
@PaulaWeb3andCrypto
4 жыл бұрын
Glad you think so!
Hi Paula...Thank you so much
@PaulaWeb3andCrypto
4 жыл бұрын
You are so welcome
thank you so for this video! watching from Madagascar Could you make videos about auditing with powerquery and powerpivot, please?
@PaulaWeb3andCrypto
3 жыл бұрын
Thanks for the idea!
Thank you very much for the video, but how about the reference between the bank and the GL not standardized. I mean here, probably reference in the GL not actually match like to like in the bank statement, example, in the GL, the reference number probably in the middle of the description, can you show us that situation, for specific probably using consist of the text. Thank you very much
I don’t think this will work...
@PaulaWeb3andCrypto
3 жыл бұрын
well? How did you get on?
@aslabivad792
3 жыл бұрын
@@PaulaWeb3andCrypto I have tried too, bank description has nothing in common apart values, your seem to be the same, bc mine are different I get null for everything when I try to merge queries, not sure what i am doing wrong. Thx