Forum Discussion

benjamin_sasin's avatar
benjamin_sasin
Icon for Resolver I rankResolver I
7 years ago
Solved

if statement in a new column not working

New to Power Query M here, I'm converting a source column's YYYYMM  to date, which works well, except it produces an error whenever the source column is null.   I'm trying to wrap an IF statement i...
Need Help
  • gpoggi's avatar
    gpoggi
    7 years ago

    Hi benjamin_sasin ,

     

    Yep, it is only syntax problem, please try instead:

     

     

    if
  [GRADYYYYMM] = null or Text.Length([GRADYYYYMM]) < 6
then
  null
else
  Date.FromText(Text.Combine({Text.Start([GRADYYYYMM],4),Text.End([GRADYYYYMM],2),"01"},"-"))

    IF SYNTAX in M Language:

     

    if <test> then <output1> else <output2> 

     

    NESTED SYNTAX (just append the if after else and everything is the same):

     

    if <test> then <output1> else if <test2> then <output2> else if <test3> then <output3> else <output4>

     

    Any question, just let me know,

     

    Regards,

     

    Gian Carlo Poggi

     

     

gpoggi's avatar
gpoggi
Icon for Responsive Resident rankResponsive Resident
7 years ago

Hi benjamin_sasin ,

 

Yep, it is only syntax problem, please try instead:

 

 

if
  [GRADYYYYMM] = null or Text.Length([GRADYYYYMM]) < 6
then
  null
else
  Date.FromText(Text.Combine({Text.Start([GRADYYYYMM],4),Text.End([GRADYYYYMM],2),"01"},"-"))

IF SYNTAX in M Language:

 

if <test> then <output1> else <output2> 

 

NESTED SYNTAX (just append the if after else and everything is the same):

 

if <test> then <output1> else if <test2> then <output2> else if <test3> then <output3> else <output4>

 

Any question, just let me know,

 

Regards,

 

Gian Carlo Poggi

 

 

  • benjamin_sasin's avatar
    benjamin_sasin
    Icon for Resolver I rankResolver I
    7 years ago

    I forgot the "then"--duh (facepalm)! Thanks a lot!