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
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)