Hi all,
I want to filter issue type , status and time
issue type = Service Request
status = in processing
time = Before last month
I just came into contact with this system, so need help. thanks.
sum(
Filter(
Descendants(
[Issue Type].[Service Request],[Issue Type].[Service Request]
),
DateBetween([Issue].CurrentHierarchyMember.get('Created at'),
'2021-01-01',
'2021-09-31')
)
)
Hi @FJ-Jay
Another method you can use is to bring the dimensions you need in the pages for filtering. Then select the opions you need.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.