Скачать или смотреть Power Query Dynamic Monthly Dynamic Depreciation Schedule Using Straight Line Method

In this video, I created a dynamic monthly depreciation schedule using straight line method with the help of POWER QUERY and loading it into a PIVOT table report.

Video chapters:
0:00 Intro
0:46 Load two tables in PQ
1:24 Create a unique beginning of months date in PQ
4:03 Create Depreciation Table in PQ
7:54 Close & Load to PivotTable Report
9:03 Test template
Watch the whole video for further explanation on the process!

Visit my channel: https://www.youtube.com/c/LinethDelaC...

Link to download the sample file:
https://www.dropbox.com/s/6v4rydl8dvx...


Link on Playlist: Learn Spreadsheet Powe Query:
   • Combine 3 workbooks using the Append in Po...  

Thanks for your time and I hope you learn something from it.

Help me to reach my target audience by sharing my videos with the right people.

Don’t forget to Subscribe!