Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
26 | |
22 | |
21 | |
16 |