Offset in CalendarTable

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)

Appreciate the help guys!

Regards
Hidayat

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

https://exceleratorbi.com.au/dynamically-show-completed-months-in-power-bi/

Hope this is helpful.

  • Brian
1 Like

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

Below is my adaptation:
Last Completed Month

Last Completed Week

Last Completed Day

@Yatz86,

Great! - glad that worked well for you.