Filtering on the key date with parameters

[harry93]

I have the difficulty of evaluating projects that were in progress on a specific deadline. The Projects table contains the date when the project was set to 'In Progress' status and when it was set to 'Done' status. You could now solve this with a parameter and then set filters on the table.

FilteredTable = Table.SelectRows(#"Geänderter Typ1", each
([statustext] = "in_Arbeit" and [arbeitsam] <= Stichtag)
or
([statustext] = "erledigt" and [erledigtam] >= Stichtag)
)

Now the reader should be able to change the parameter. Does anyone have an idea for me on how to solve this?

[ibarrau]

Hi. The power query params are not usually ment to work like that. Those params help us filter the whole data for an audience. They are not suposed to change too often. If you want a reader to change between to project status I would say that you need to import all that data. Import done status and in progress status. Make sure you have a column to filter between them and just add a slicer to the report page.

I hope that helps,