Notifications
Clear all
Power BI
3
Posts
2
Users
0
Reactions
112
Views
Topic starter
Hi Mynda,
I have a table where I'm trying to work out how many days each agent logged in, filtered by the last 7 days. Am trying the below, but it does not work as expected.
last7daystaffworking =
COUNTROWS(FILTER(
'RAW Data Agent Performance',
'RAW Data Agent Performance'[Date] >= MAX('DIM DateTable'[Date]) - 7
&& 'RAW Data Agent Performance'[Date] <= MAX('DIM DateTable'[Date])
))
Are you able to please point me in the right direction?
Posted : 03/08/2024 5:47 am
Hi Danielle,
Please share a small sample file with the desired result and your measure returning the incorrect result.
Mynda
Posted : 05/08/2024 12:39 am
Topic starter
I've since worked out the issue. Thanks 🙂
Posted : 07/08/2024 12:42 am
