Offset in CalendarTable

Power Query
1

Hi all,
Need your help in my new case issue. I would like to use offset in Calendar table. The reason is to filter easily the last completed (year/month/week) from my sales data table. Sourced around youtube and came across a calendar table with offset (Year/Month/Week) from youtuber AviSingh.

Is there a way to integrate the offset function into Sam’s calendar table?

Attached is the source file that I am using (my fail attempt) :zipper_mouth_face:
Calendar PBI.pbix (170.9 KB)

Capture
Capture.JPG1546×866 163 KB

Appreciate the help guys!

Regards
Hidayat

2

@Yatz86,

I came across this blog post yesterday on dynamically identifying completed sales months. Not exactly the same offset method you mentioned, but a very straightforward approach that seems like it could get you to the same outcome.

Hope this is helpful.

  • Brian
1 Like
3

Super! Talk about adapt improvise overcome, this solution works too :grinning:
Thanks a lot @BrianJ

Below is my adaptation:
Last Completed Month

Capture
Capture.JPG1686×197 52.3 KB

Last Completed Week

Capture2
Capture2.JPG1743×189 54.7 KB

Last Completed Day

Capture3
Capture3.JPG1711×155 43 KB

4

@Yatz86,

Great! - glad that worked well for you.