Power query to reconcile accounts that do not have a common column

Подписаться 22 тыс.

Просмотров 5 тыс.

50% 1

#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.c...
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

Опубликовано:

15 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 17

@wayneedmondson1065 4 года назад

Hi Paula.. great trick.. thanks for sharing it. Thumbs up for The Excel Club!!

@KD-xp2eo 2 года назад

Thank you so much!!! This helped me out a ton!!!

@jaliali84 4 года назад

Thanks, Paula this is simple and powerful

@PaulaWeb3andCrypto 4 года назад

good stuff!!

@sleek12 3 года назад

I really need this, am following it.

@PaulaWeb3andCrypto 3 года назад

:-)

@ezekieladesawe239 4 года назад

Awesome trick. This video is very helpful and valuable

@PaulaWeb3andCrypto 4 года назад

Glad you think so!

@SimX9000 3 года назад

Life saving. Thank you

@aasishkumar267 4 года назад

Hi Paula...Thank you so much

@PaulaWeb3andCrypto 4 года назад

You are so welcome

@hasinarafenoarisoa7063 3 года назад

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!

@azmanfc 3 года назад

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

@evanyeung3801 3 года назад

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