Count Entries at Weekend previous 3 Weeks

Hello everyone!

I need to figure out if any sales have been proceed on the weekend for the last 3 completed weeks.

I have this fact sheet:

The key 'AA' means sales on weekend.

Regardless of if the sale was on Saturday or Sunday or both, it always counts as 1.

If there are entries with key 'AA' for the previous 3 weekends for an ID, then I need a TRUE. If not, then a FALSE.

How would you do that?

I already have a calendar table that shows me the week offset:

I need a measure/ approach based on Dax without any transformation in PQ.

0 REPLIES 0

Helpful resources

Announcements

Check out the November 2025 Power BI update to learn about new features.

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.