Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |