Very clear, useful, and to the point. Thank you so much.

I truly appreciate how efficiently you explain even the most complex issues with down to earth examples! Very well done!

@vincentlacomme

Жыл бұрын

Thank you for your message Average Joe !

Great session with so many hidden gems - this is on my watch again list.

@vincentlacomme

2 жыл бұрын

Thank you for you kind words, Grainne D. If you have any question, you can contact me via Linked in :)

@AverageJoe-Ohio

Жыл бұрын

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

Thank you for sharing this.

@vincentlacomme

Жыл бұрын

Thank you for you comment :)

Really like .❤

Very Interesting session. Contain lot of techniques how PQ can be useful in financial reporting.

@vincentlacomme

2 жыл бұрын

Thank you for you kind words Muraleedharan. If you have any question, you can contact me via Linked in :)

Excellent tutorial

@vincentlacomme

Жыл бұрын

Thank you for the comment Muhammad, please contact me via Linkedin or Twitter so I can send the file.

BTW weldone on the French beating Denmark yesterday FIFA Worldcup!

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

@vincentlacomme

Ай бұрын

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.

Really like how the TB was created in Power Query

@vincentlacomme

2 жыл бұрын

Thank you for you kind words Westley. If you have any question, you can contact me via Linked in :)

Awesome tricks and great content Vincent 👏. Just wondering if you have a chance to share exercise files ?

@vincentlacomme

Жыл бұрын

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 ?

@vincentlacomme

Жыл бұрын

Thank you for you comment Riham. Please can contact me via Linked in or Twitter for the demo files.

Could you please share the files to practice?

@vincentlacomme

Жыл бұрын

Thank you for you comment Aby. Please can contact me via Linked in or Twitter for the files.

Can you share the file please

@vincentlacomme

Жыл бұрын

Thank you for you comment Jason. Please can you contact me via Linked in or Twitter for the files.

Great vid can you please share the file 🙏

@vincentlacomme

Жыл бұрын

Thank you for you comment Will. Please you can contact me via Linked in or Twitter for the files.