I feel this question would apply to others but I have searched for days on the web and not found an answer. We use an ISO calendar. Each year has 13 x 4 week periods and, every six or seven years we have a leap year with 53 weeks. How can I get the last year’s sales for week 53 (FP 13 Week 5) to …

@billlee , Ha! This was a tough SOB, but I finally cracked it. Combination of data modeling changes and DAX. Added the following table to the data model connected by an inactive relationship. [image] If the relationship in either measure is inactive, it forces the fifth row to remain. Even thou…

How can I get the 53 week last year to appear?

DAX DAX Calculations

Keith July 4, 2021, 12:03am 8

are you using the extended date table that Melissa set up within forum?

This is ISO calendar information in it that might make your calculation easier.

thanks
Keith