Hi ALL, I am in a scenario, wherein I need to do week on week comparison for each month current week vs previous week, i have used the time intelligence week and previous week calculation showcased in the forum, but for me currently the challenge is the offset value works on a logic of 7 days irres…

Think I was exploring the same angle :wink: I’ve added a [YMW number] and a [Custom week] number to your Dates table with this logic. InsertWeekOfMonth = Table.AddColumn(InsertWeekNumber, "Week Number2", each Date.WeekOfMonth([Date], Day.Sunday)), InsertWkMnthNum = Table.AddColumn(InsertWeekOfMont…

Week on Week Comparison - Time Intelligence

DAX DAX Calculations

Melissa May 13, 2020, 8:31am 15

@BrianJ Sounds like a great plan to me
.