Forum Discussion

M001's avatar
M001
Helper I
2 years ago
Solved

Turn column names in M Language defined by variables

Hi there,    I would like to check the data in my latest month column against previous month, and return Y for rows with data in the last two columns not equal   The tricky part is the number of ...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi M001 

     

    if List.IsDistinct(List.LastN(Record.ToList(_),2)) then "N" else "Y"

    Stéphane 

slorin's avatar
slorin
Super User
2 years ago

Hi M001 

 

if List.IsDistinct(List.LastN(Record.ToList(_),2)) then "N" else "Y"

Stéphane 

M001's avatar
M001
Helper I
2 years ago

Thank you, Stephane and everyone. I think this is the simplest approach among all the helpful feedback, just that the N and Y were placed wrongly, and we need to make sure the two columns must be at the last two position