Forum Discussion
Solved
Create table based on an input
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.selected...
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
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