Filter with conditional custom column?

[Nothnless]

Hi, is there syntax for filtering using an if statement in a custom added column? I don't have dax.

example: If paramater1 = "Yes" then filter column1 to paramater1 elseif paramater1 = "No" then filter column2 to paramater1

Thanks.

 

[ranman256]

Public Sub Filter1()
Dim rng As Range
Dim iCol As Integer

Select Case parameter1
   Case "Yes"
        iCol = 1
    Case "No"
        iCol = 2
End Select

Range("A1").Select
Set rng = ActiveSheet.UsedRange
Selection.AutoFilter
rng.AutoFilter Field:=iCol, Criteria1:=parameter1
End Sub

 

[Nothnless]

Public Sub Filter1()
Dim rng As Range
Dim iCol As Integer

Select Case parameter1
   Case "Yes"
        iCol = 1
    Case "No"
        iCol = 2
End Select

Range("A1").Select
Set rng = ActiveSheet.UsedRange
Selection.AutoFilter
rng.AutoFilter Field:=iCol, Criteria1:=parameter1
End Sub

This is a subroutine right? I can put this in, or call it from Power Query?

 

[ranman256]

if you have a query, you wont need the code.

 

[Nothnless]

if you have a query, you wont need the code.

My main query does a whole lot of other stuff but I want to primitively filter the query based on the conditions of a cell that the user selects from a drop down. I've already created the parameter queries that feeds into my main query to get the selections but I'm stuck on being able to filter my main query based on the cell selection. I hope this makes more sense, thanks.

 

[Nothnless]

Never mind I figured it out. I first had to create a column [dummy] saying if paramater1 = "Yes" then [column1] elseif [column2]. Then I created another column [dummy2] saying if "drop down selection" equals [dummy] then true else false. Then I set the [dummy2] filter to true.