Forum Discussion

Sams11's avatar
Sams11
Frequent Visitor
2 years ago
Solved

Filter on status and date condition

Hi all, please help me with this following questions: I am new to powe bi and trying this...   I have column with status and updated date. I am not sure how to achieve this, kindly provide your i...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Sams11's avatar
Sams11
Frequent Visitor
2 years ago

But I have one problem here.. Since I am using DirectQuery-> I do not have access to table view and custom columns...

I can only do right click "Add Column", Is there a way I can acheive this?