Solved: Re: If statement in Power Query that removes last ...

Anonymous · ‎04-09-2020

Hi!

I am trying to make a new column that has an if statement in a Power Query that removes the last letter if it is equal to "*" This is what i got so far and i am not sure on how to fix it.

All help would be greatly appreciated!

All the best,

Pétur

az38 · ‎04-09-2020

Hi @Anonymous

try Text.BeforeDelimiter

= Text.BeforeDelimiter([guestName], "*")

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

az38 · ‎04-09-2020

Hi @Anonymous

try Text.BeforeDelimiter

= Text.BeforeDelimiter([guestName], "*")

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Greg_Deckler · ‎04-09-2020

...then Text.Start([guestName],Text.Length([guestName])-1)...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎04-09-2020

This was actually Giving me an Error, was messing up with the Code when i took the picture so thats why i forgot it probably!

If statement in Power Query that removes last letter

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024