Forum Discussion
Filter on status and date condition
Hi Sams11
1.You can insert new step after named(Custom1)
2.and insert the follwing code
=Table.SelectRows(the last step name,e.g #"Changed Type", each ([issuetype] ="Defect") and ([status]="Closed"))3.Then insert a new step again, named Custom2
=Table.SelectRows(Custom1, each [date] >#date(2023, 4, 1) and [date] < #date(2023, 4, 30))Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Of course if you'd like to FILTER with these conditions, add a new step, and in the formula bar, enter:
= Table.SelectRows(PriorStepOrTableName, each Status] = "Closed" and [updated date] > #date(2023, 4, 1) and [updated date] < #date(2023, 4, 30))
--Nate
This is my exact jira query which I am tryingto achive in power BI..
issuetype = Defect AND status = Closed AND (status changed to Closed after '2023/04/01' AND status changed to Closed before '2023/04/30')
Hi Sams11
1.You can insert new step after named(Custom1)
2.and insert the follwing code
=Table.SelectRows(the last step name,e.g #"Changed Type", each ([issuetype] ="Defect") and ([status]="Closed"))3.Then insert a new step again, named Custom2
=Table.SelectRows(Custom1, each [date] >#date(2023, 4, 1) and [date] < #date(2023, 4, 30))Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.