Create table based on an input

[vstopp]

I have a table with a field length of stay (LOS).  I would like to have all patients with a LOS > X put into another table.  I believe I would use power query editor for this using the Table.selectedRows, but I don't know where to start.  

I would then like to use this table for another form to show data related to the users selected.

Thank you in advance.

Valerie

[v-lili6-msft]

HI  @vstopp 

You could use this button to go to power query in power bi desktop.

In Updated ribbon, use this button

In old version

https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#power-query-editor

Then in power query, you could use built-in function to get it as below:

of course, you duplicate the basic table and do the filter on that duplicate table.

Regards,

Lin

[Greg_Deckler · Accepted solution]

In DAX you could create a new Table and use this formula:

New Table = FILTER('Old Table', [LOS] > X)

In Power Query, create a new query as a reference of your existing query then just use the GUI to filter to LOS > X 

[vstopp]

I did create the table (using the new table button).  Now how do I add an input box for X and incorporate it into the create table verbage?

tableLOS = Filter (CostUtilization_LOS, [losNumberDays] >= 500)