Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi team,
I'm building a filter for a calculation so that it computes data between 01-01-2016 until last Friday.
How can I filter the calculation until "last Friday"?
I thought about doing the below, assuming today is Tuesday, and replicate the process all other days of the week but it seems very long and unnefficient
*for tuesdays*
IF (WEEKDAY ( TODAY() , 1) = 3 ; *if today is tuesday*
TODAY() - 4) ;
IF(weekday ( TODAY() , 1) = 4; *if today is wednesday*
TODAY() - 5) ;
IF ....
Solved! Go to Solution.
Please try the expression below.
weekday = WEEKDAY('Table'[Date],1)
lastFriday = IF('Table'[weekday]=7,'Table'[Date]-1,'Table'[Date]-'Table'[weekday]-1)
Regards,
Charlie Liao
Please try the expression below.
weekday = WEEKDAY('Table'[Date],1)
lastFriday = IF('Table'[weekday]=7,'Table'[Date]-1,'Table'[Date]-'Table'[weekday]-1)
Regards,
Charlie Liao
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |