Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I have transform a table into a list.
What I am trying to do is to tell PBI not to take columns that start with "P_"
The idea is to use the funciton below:
= List.Select( Table.ColumnNames(#"Changed Type"), each Text.StartsWith(_, "P_"))
But instead of saying "Text.StartsWith(_, "P_")" , I want to say "Text does not stats with (_, "P_")".
How could I achieve that ?
Thank you
Solved! Go to Solution.
each not Text.StartsWith(...)
--Nate
each not Text.StartsWith(...)
--Nate