Forum Discussion
Solved
List.Accumulate returning wrong value
Hiya all, I am working with a table as below : The task is as follows : 1. Extract the month name using List.Accumulate as below : Table.AddColumn(ExtractAccountName, "Month Name", ...
in 4th row, right there is a "mar" in Jiomart
Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,(x)=> Text.Contains([Name],"_"&x,Comparer.OrdinalIgnoreCase)){0}?)sorry for my carelessness.
Now the error message is as below :
Because probably the "text.contains", in this case will return a true, right?
Thanks for being in my corner. really appreciate.
Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,(x)=>
Text.Contains([Name],"_"&x,Comparer.OrdinalIgnoreCase)){0}?)sorry for my carelessness.
That worked !! wdx223_Daniel . Thanks a ton.