Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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"))
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
77 | |
73 | |
71 | |
45 | |
42 |
User | Count |
---|---|
48 | |
47 | |
29 | |
28 | |
28 |