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.
Hi
I'm gettting the data form my SAP Data Base an when I select the ORDR table I know that I only want the records where the Canceled filed is N.
Can I filter this Data in this moment to work alway with this data filtered yet
regards
Solved! Go to Solution.
In Query Editor, select the drop down for the column and unselect "Select All" and then select "N". The M code for this is:
#"Filtered Rows" = Table.SelectRows(#"Previous Step", each ([Column] = "Value"))
In Query Editor, select the drop down for the column and unselect "Select All" and then select "N". The M code for this is:
#"Filtered Rows" = Table.SelectRows(#"Previous Step", each ([Column] = "Value"))
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |