Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi i have a calculated value i.e 1:2356 i want to show only right value of ":".
Solved! Go to Solution.
Use any of the following where Data is the column name
= Text.AfterDelimiter([Data],":")
= Text.Split([Data],":"){1}
Use any of the following where Data is the column name
= Text.AfterDelimiter([Data],":")
= Text.Split([Data],":"){1}