Forum Discussion
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.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
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
3 Replies
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
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)
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
