Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

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:

IDDateValueKey
00103.03.20215AB
00104.03.20216AB
00105.03.20217AB
00106.03.20218AA
00107.03.20211AA
00205.03.20214AB
00206.03.20212AA
00207.03.20213AA

 

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:

DateWeekOffset
28.02.2021-1
01.03.20210
02.03.20210
03.03.20210
04.03.20210
05.03.20210
06.03.20210
07.03.20210

 

 

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

No RepliesBe the first to reply