Forum Discussion
monojchakrab
Resolver III
Resolver IIIList.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.
monojchakrabResolver III
Resolver IIIwhoops did not realise that wdx223_Daniel . Is there a workaround not to pick up the "mar" from the name of the account string.
would splitting the column using the delimiter "-" work better in this case?
wdx223_Daniel
Community Champion
Community ChampionTable.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,each
Text.Contains([Name],"_"&_,Comparer.OrdinalIgnoreCase){0}?)- monojchakrab
wdx223_Daniel - It adds column with lists as it should, but the list is populated with errors on every row. Am I getting something wrong?
- monojchakrab
- wdx223_Daniel
Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,(x)=> Text.Contains([Name],"_"&x,Comparer.OrdinalIgnoreCase){0}?)