When working with Excel data,
it is often necessary to calculate results based on yesterday’s date rather than today.
This example shows how to create a dynamic summary
that automatically updates using Power Query and a reference date.
엑셀 작업을 하다 보면
오늘이 아닌 전날 기준으로 데이터를 집계해야 하는 경우가 많습니다.
이번 예제에서는
TODAY 함수를 활용하여 전날 기준 날짜를 만들고
해당 날짜까지 자동으로 합계를 계산하는 방법을 소개합니다.
(이미지 삽입)
Power Query를 사용하면
날짜가 변경되더라도 새로고침만으로 자동 반영되며
수식 없이도 간단하게 구현할 수 있습니다.
videolink - https://youtu.be/kVFPzWXGQng
Download the sample file below.
You can download the zip file in [자료실][Download] page
The file name is 37.전날기준자동합계(dynamic summary).
Use the English M code provided for your dataset.
✔ Download the ready-to-use Power Query template below
✔ Just copy and paste the M code – works instantly
The original sample file is based on a Korean dataset.
You can apply the English M code to adapt it to your own data.
--------------------------------
Need a custom automation for your Excel workflow?
I can build a tailored solution based on your data.
✔ Used in real-world business automation
✔ Saves hours of manual work
minbedata@gmail.com
You can pay via PayPal.
You can also contact me via Upwork for secure payment and project handling.
<a href="https://www.upwork.com/freelancers/~01eb52dbd212cffc17" target="_blank">
Hire me on Upwork
</a>
You don't worry about conversing with me.
My Major is an English literature, so I can speak English fluently and read, listening, writing proficiently
korean version web address (한국버전) is
<a href="https://blog.naver.com/minbe-data" target="_blank">네이버 블로그 바로가기</a>