Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power Query if statement with condition dependent on Language format

Hi folks,   I'm stumped at this problem and tried to make it simpler by chopping the column [Language] into two columns by delimeter "-" but it doesn't seem to solve my issue.   So here's what I'...
Need Help
Tips and Tricks
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,
You were almost there.

if [SourcePropertyDisplayName] = "Global IOS App US/UK" and Text.Start([Language], 2) = "fr" then "Global Global IOS App US/UK French" else  "Global IOS App US/UK English"

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks so much Nathaniel! If I have let's say 3 sourceNames as I mentioend above, do i keep repeating the if then statement 3 times or nest it somehow? 

 

 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,

    if [SourcePropertyDisplayName] = "Global IOS App US/UK" and Text.Start([Language], 2) = "fr" then "Global Global IOS App US/UK French" else if [SourcePropertyDisplayName] = "x" then "y" else "Global IOS App US/UK English"

     Yes, so I added another condition if x then y in between.  Look at the picture, shows you three results. If you are getting into this, let me recommend KenPuls  book, M is for (DATA) Monkey. Easy read and really useful.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel