Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @NISH72,
use the function Table.SelectRows.
Example:
let Source = #table( {"SalesID", "Sales", "Comment"}, { {1, 778, "Good"}, {2, 675, null} } ), Result = Table.SelectRows(Source, each [Comment] <> null) in Result
Hi @NISH72,
use the function Table.SelectRows.
Example:
let Source = #table( {"SalesID", "Sales", "Comment"}, { {1, 778, "Good"}, {2, 675, null} } ), Result = Table.SelectRows(Source, each [Comment] <> null) in Result