Just wondering, in your DAX formula "Date.From", couldn't I just change the number to text directly by using the transform text tools vs inserting a second formula "Number.ToText", or does that not work?
Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation
Thank you for your interest ! I am not sure how it could be fully automated unless there would be at least one column with a common property (Voucher number). The property could be an equal match or partial match.
very clear and useful. However I stuck with the last step when present the financial statement in the pivot table. In the P/L Statement will shows the Sales as negative whereas the cost is positive which usually when presenting the FS, we will omit the negative sign. Another issue is , if the income is showing a debit balance instead of credit balance. what formula should i use in the custom column.
Thanks ! I would suggest 1- reversing the sign so that sales are positive 2- adding a balance column (equal to debit minus credit) and only working on that column
I truly appreciate how efficiently you explain even the most complex issues with down to earth examples! Very well done!
Thank you for your message Average Joe !
Great session with so many hidden gems - this is on my watch again list.
Thank you for you kind words, Grainne D. If you have any question, you can contact me via Linked in :)
Just wondering, in your DAX formula "Date.From", couldn't I just change the number to text directly by using the transform text tools vs inserting a second formula "Number.ToText", or does that not work?
Very clear, useful, and to the point. Thank you so much.
Thank you for your kind words !
Very Interesting session. Contain lot of techniques how PQ can be useful in financial reporting.
Thank you for you kind words Muraleedharan. If you have any question, you can contact me via Linked in :)
Excellent tutorial
Thank you for the comment Muhammad, please contact me via Linkedin or Twitter so I can send the file.
Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation
Thank you for your interest ! I am not sure how it could be fully automated unless there would be at least one column with a common property (Voucher number). The property could be an equal match or partial match.
Thank you for sharing this.
Thank you for you comment :)
Awesome
very clear and useful. However I stuck with the last step when present the financial statement in the pivot table. In the P/L Statement will shows the Sales as negative whereas the cost is positive which usually when presenting the FS, we will omit the negative sign. Another issue is , if the income is showing a debit balance instead of credit balance. what formula should i use in the custom column.
Thanks ! I would suggest 1- reversing the sign so that sales are positive 2- adding a balance column (equal to debit minus credit) and only working on that column
BTW weldone on the French beating Denmark yesterday FIFA Worldcup!
Really like how the TB was created in Power Query
Thank you for you kind words Westley. If you have any question, you can contact me via Linked in :)
Really like .❤
Awesome tricks and great content Vincent 👏. Just wondering if you have a chance to share exercise files ?
Thank you for the comment @Tolga. Please contact me via Linkedin or Twitter so I can send the file.
Hello, How can we get the data, spreadsheet and the powerpoint ? Is their any link to download the data ?
Thank you for you comment Riham. Please can contact me via Linked in or Twitter for the demo files.
Can you share the file please
Thank you for you comment Jason. Please can you contact me via Linked in or Twitter for the files.
Could you please share the files to practice?
Thank you for you comment Aby. Please can contact me via Linked in or Twitter for the files.
Great vid can you please share the file 🙏
Thank you for you comment Will. Please you can contact me via Linked in or Twitter for the files.