Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello altrusits,
Can someone help me how to choose a column name as a source for the function List.Accumulate ?
Thanks in advance.
My code is as follows:
= Table.AddColumn(#"previous step", "new column", each List.Accumulate(Table.ToList(#"Table list here, this table has many columns so I want to specify the column name"),"",(state,current)=>
if Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)
then current&"/"&state
else state))
Solved! Go to Solution.
Hi @sparvez,
I guess you are questioning this bit?
Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)You can call a column in a table using the name of the column using
Table.Column(table as table, column as text) as list
Kind regards,
John
Hi @sparvez,
I guess you are questioning this bit?
Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)You can call a column in a table using the name of the column using
Table.Column(table as table, column as text) as list
Kind regards,
John
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 13 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |